DBMS_OUTPUT

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bagieta
Posts: 21
Joined: Tue 09 Nov 2004 08:02
Location: Poland

DBMS_OUTPUT

Post by Bagieta » Wed 15 Dec 2004 15:57

Is there a possibiilty to use ODAC to get DBMS_OUTPUT information?
I don't know how to get that buffer.
Maybe there is a simplier way and there is no possibility to use ODAC.
Thanks in advance

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Fri 17 Dec 2004 12:58

You can use DBMS_OUTPUT.GET_LINE (LINE OUT VARCHAR2, STATUS OUT NUMBER) procedure.
Procedure gets a single line back that has been buffered.
Output parameters:
line
This line will hold the line - it may be up to 255 bytes long.
If database is in codepoint semantic, it may be up to 255 characters.
status
This will be 0 upon successful completion of the call. 1 means
that there are no more lines.
If you wish to obtain more detailed information please see Oracle documentation about DBMS_OUTPUT package.

Post Reply