Not able to get result set from stored procedure in ESQL?

Question

I am calling external stored procedure from esql., where input is also clob and output also clob.

i have to send input and and get response from Oracle DB Stored procedure.

but im getting error as SQL TYPE NOT FOUND 0 Error...

Any suggestions...

#MessageBroker #IIB #ESQL

CALL pro_call(P_DATA_CLOB,P_INIT_LOGGING) INTO V_RETRUN;

CREATE PROCEDURE pro_call(IN P_REQUEST CHAR ,IN P_INIT_LOGGING BOOLEAN) 
RETURNS CHAR
LANGUAGE DATABASE 
EXTERNAL NAME "INTERFACE.LPB_SERVICING.GET_SERVICE";

have tried this, but getting error response.

Please let us know if any one used this and get success response.

Answer 1

I think the problem is the BOOLEAN parameter in your declaration. Oracle SQL doesn't have a BOOLEAN type, so there is no mapping between the ESQL BOOLEAN and an Oracle type.

https://www.ibm.com/docs/en/app-connect/11.0.0?topic=functions-data-types-values-from-external-databases