SQL_GetVariable

[Obscured]

I write a plugin with Delphi7. Can I execute some procedure with output CLOB parameter from my plugin? Now I get ORA-06502 error if parameter value returned by the procedure is more than several kilobytes.

 

[Marco Kalter]

All variables are declared as varchar2 data type for Plug-In queries, so it is indeed limited to 4000 bytes. If you to perform more refined queries, you will need to use database access components within your Plug-In.