Re: Usefulness of DBMS_OUTPUT.PUT_LINE?

Ramon F Herrera wrote:
>
> Being a C programmer, I am accustomed to the 'printf' statement
> having 2 different purposes:
>
> - interactive debugging
> - returning some value(s) to the calling program.
>
> What about the DBMS_OUTPUT.PUT_LINE utility?
> Is is used only to display stuff from SQL*PLUS,
> and therefore limited to interactive sessions?
>
> OR
>
> DBMS_OUTPUT.PUT_LINE is really flexible (like 'printf')
> and it can be use, for instance to return some value
> from a stored procedure to a remote Java client?
>
> TIA,
>
> -Ramon F. Herrera

Check out the utl_file package, or dbms_application_info

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."