Re: dbms_output, where do they go?

js9sf_at_fnpx19.fnal.gov (Jiangeng Sun) wrote:

>Hi all,
 

>I have successfully written several packages , and
>I trap all the errors and use dbms_output to write
>the messages to the terminal. They all work fine
>when I use sqlplus. Now if I call the package from
>OCI or pro*C or VB or form4.5 or whatever, how can I
>get all those messages ? I tried somthing like
 

>char buff[256]="uuu";
>exec sql
> begin
> mypackage.function1(bla); -- this function write at least 5k worth of messages
> end;
>end sql;

>while ( *buff != NULL){
>exec sql
> begin
> dbms_output.getline( :buff);
> end;
>end sql;
> puts(buff);
>}
 

>This one did not work, there is nothing in buff no mater how many
>times I call getline.
 

>any hints?

Might you be better off using the DBMS_PIPE package instead of DBMS_OUTPUT? Just curious as to whether you've tried that approach or not...

Mike

>j.g.
Received on Wed Apr 17 1996 - 00:00:00 CEST