ora 06502, ora06512 when using package.callstringfunction

[jchavezgomez]

Hello,

I am using the package.CallStringFunction to make a call to a stored procedure that returns a VARCHAR2 value.

The oracle stored procedure written in PL/SQL can return a VARCHAR2 with length up to 8192 characters. If the stored procedure returns a varchar2 value with length

 

[Marco Kalter]

The CallStringFunction always returns a SQL varchar2, which is limited to 4000 bytes. If you want to return more bytes, you need to use a TOracleQuery with a corresponding PL/SQL Block with the function call, and declare the return value as an otPLSQLString. This datatype is limited to 32KB instead of 4KB.

 

[jchavezgomez]

Thanks Marco. Appreciated.