Re: print statement

First in SQL*Plus type
set serveroutput on size 1000000
The size is the buffer size so that you can display a lot of output ( check set servertput on usage for more info). This has to be set to display terminal output. ( Alternatively, there are Oracle pre-built packages that will let you set this parameter within a procedure itself, instead of in SQl*Plus)

Next,
In your procdure, at points where you want to dispaly output, type
dbms_output.put_line(variable)
where variable is some variable value you wnat to display. If you want a text string type,
dbms_output.put_line('LOCATION1');

Recompile your procedure and execute it. That's it. You'll find yourself using this quite a bit.

Venkat

Louis wrote:
>
> Greetings All, I want to do some debugging in one of my procedures.
> I would like to print at various points in the procedure some text such
> as "location1". In SQL Server you can just issue a print 'location1' and
> it will output the value to the calling program. Does Oracle have something
> similar to this?
>
> Thanks, Louis
> frolio_at_videoshare.com
 

-- 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
        _   __         __        __
       | | / /__ ___  / /_____ _/ /_   Email :
       | |/ / -_) _ \/  '_/ _ `/ __/    venkat1_at_one.net
       |___/\__/_//_/_/\_\\_,_/\__/     venkat_rajagopal_at_yahoo.com

                  < http://w3.one.net/~venkat1 >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++