Re: Can dbms_output.put_line reflect sql output/feedback information ?

Hi this is an easy one. When you first login to your sqlplus session you need to do the following before you execute the procedure

    set serveroutput on

Now do the following

    execute sbs.test.func2('ss','ddd');

Obviously within the procedure you will need an output clause dbms_output.put_line ('failed to find a null revision mobjid / cpobjid ! ('||mod_objid||')(*'||c_objid||'*)');

hope this helps

regards

Tony Rees
Startex Networks

"Wanda Zoe" <clarioneer_at_hotmail.com> wrote in message news:bb523k$orn$1_at_newsreader02.ops.uunet.co.za...
> At the moment...
> SQL> exec sbs.test.func2('ss','ddd');
> PL/SQL procedure successfully completed.
>
> I want it to say
> SQL> exec sbs.test.func2('ss','ddd');
> 1 row created
> 1 row updated
> ....etc....and then ..
> PL/SQL procedure successfully completed.
>
>
> Currently I'm adding lots of dbms_output information, and this I can view,
> but i want to add
> the actual sql feedback in there as well....
>
> Any help will be appreciated.
>
>
>
>
Received on Tue Jun 10 2003 - 03:04:59 CDT