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
how to acess dbms_output in stored procedures
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.
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.