Re: Can IWS Call Stored Procedures?

["Nadir Amra" <amra@xxxxxxxxxx>]

ANSWERS BELOW

> 1. Can an IWS service call a SQL stored procedure? It is one thing 
> to execute SELECT, UPDATE, INSERT, and DELETE statements. It is 
> another thing to CALL stored procedures.

YES.

> 2. Are there limiting conditions when using IWS to call SQL stored 
> procedures? 

NOT THAT I KNOW OF.


> 3. Are there size limits on parameters that can be handled with this
> approach? For example, suppose I want a stored procedure to return a
> row set as a JSON string in a CLOB (10M) parameter. Could an IWS 
> service that calls this stored procedure handle the CLOB parameter? 
> Are there any limits on parameter size other than the limit of a CLOB 
itself?
>

NO LIMITS OTHER THAN THOSE IMPOSED BY SYSTEM, JAVA TOOLBOX JDBC DRIVER. IF 
YOU PLAN ON RETURNING LARGE OBJECTS THEN YOU SHOULD ENSURE SERVER HAS 
ENOUGH MEMORY.