TOraSQL output...

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
[email protected]
Posts: 1
Joined: Wed 26 Aug 2009 14:59

TOraSQL output...

Post by [email protected] » Wed 26 Aug 2009 15:07

I am wanting to output PL/SQL results using the TOraSQL component... Currently, I have one that calls DBMS_OUTPUT.GET_LINE(:RET_VALUE, :RET_STATUS); to return DBMS_OUTPUT to a parameter... The problem is, I'm limited on size...

ORU-10027: buffer overflow, limit of 1000000 bytes

Is there a way around this?

Thank you.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 27 Aug 2009 07:24

The maximum size of the ftString parameter can be 32767. You need to set the Size property of the RET_VALUE parameter to a value that will be large enough.

Post Reply