Re: pl/sql problems

Thomas Gsuck (gsuck_at_rvs.uni-hannover.de) wrote:
> hi out there in netland:
 

> I have some trouble using pl/sql. It lacks i/o like "printf" or sth similar to that.
> But I need to do some output every now and then.
> With SQL*Plus I can use "PRINT", but this can only handle ONE variable.
> The trick with using "dbms_output.putline('Text" || var) does not work within pl/sql.
> I always get "putline must be declared..." when using this.

it is dbms_output.put_line('Text'||var);

                    ^^^notice the underscore.

you can also use dbms_output.put('Text'||var); for text w/o a linefeed/cr and use dbms_output.new_line for the linefeed/cr when you need it.

Important note: use the command "set serveroutput on" before executing your pl/sql block to see the output.

• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sean_Stasica_at_stortek.com
• - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -