Devart Forums

Hello,
i'm evaluating acess from delphi to oracle and mysql.
My question is, if it's possible to access oracles dbms_output in stored procedures and how to do it.
Thank you for qour help
regards
markus

Hello

Yes, you can use DBMS_OUTPUT for Oracle:

At first you should enable DBMS_OUTPUT:
begin
DBMS_OUTPUT.ENABLE(10000); // 10000 - size of buffer
end;

Execute the following script to put a line:
begin
DBMS_OUTPUT.put_line('test');
end;

Execute the following script to get a line:
begin
DBMS_OUTPUT.get_line(:line, :result);
end;

You can find more detailed information about this in the Oracle documentation.

hello,
i tested it and it works well for me
Thanks for your help
I will buy unidac, great tool

Hello

It is good to see that this problem has been solved. If any other questions come up, please contact me.