TOracleScript: need to see dbms_output output

[nicofari]

Hello,

I am using D7 with DOA standard 4.0.7.1. and I am using a TOracleScript to launch some PL/SQL procedures which use dbms_output to give some feedback.
I would need to show this output in the TOracleScript.output.
I tried adding a
set serveroutput on
before my calls but with no success.
Does any alternative way exist ?
Thanks in advance
Bye
Nicola

 

[Marco Kalter]

You will need to use dbms_output calls. For example:

begin
  dbms_output.enable(100000);
  my_procedure1;
  my_procedure2;
end;
/

After executing the script you can use dbms_output.get_line or get_lines to retrieve the output.

 

[nicofari]

Hi Marco,
I am using dbms_output, yes.
In your example I have, say:

procedure my_procedure1
is
begin
dbms_output.enable(1000000);
dbms_output.put_line('Output that I see in sqlplus or in command window of plsql developer but not in toraclescript.output');
end;

so I am using these methods.
I've setted to true every output options of TORacleScript .....

 

[nicofari]

Ops sorry sorry I've answered too quick!!
I'll try thanks

 

[nicofari]

I changed my procedure to insert msg rows in a msg table, instead of issuing dbms_output.put_line commands, after seeing that this is the way you can use dbms_output.get_lines anyway.
So I am ok now but I am curious: I checked that, in a PL/SQL developer's command windo,w the dbms_output output is visible. I thought that TOracleScript was the core of plsqldev command window, but it seems that I was wrong ?

 

[Marco Kalter]

Yes, you were wrong. PL/SQL Developer's Command Window does not use a TOracleScript component, but has its own interpreter.