Re: print statement

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/04/25
Message-ID: <7jqN4.57506$cZ.96148@typhoon.southeast.rr.com>#1/1

Louis,

You need to use "set serveroutput on" command in your SQL*Plus session, and dbms_output package in your procedure. As an alternative, you may use "utl_file" package, but it may require changes in your init.ora file.

Paul Druker

"Louis" <frolio_at_videoshare.com> wrote in message news:8e50bl$pjk$1_at_bob.news.rcn.net...
> 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
>
>
Received on Tue Apr 25 2000 - 00:00:00 CDT