Re: put_line/get_line and set option ?
Date: 1995/05/26
Message-ID: <D96uHn.2t6_at_eskimo.com>#1/1
It worked for me. You must use "set serveroutput on" at "SQL>" prompt, not in the PL/SQL. Also, make sure that "serveroutput" is one word, not two. If all else fail, make sure that your dba ran the "catproc.sql" which creates all those stuff (such as dbms_output, etc) and grant access to public.
Have fun.
Kim
vkj (vkj_at_ctt.bellcore.com) wrote:
: Hi,
: I want to debug a procedure using put_line/get_line. dbms_output package
: exists on the database and the procedure containing put_line compiles
: successfully.
: The problem I am facing is how to turn on output. When I run "set server
: output on" command, it says "Invalid set" option. I am using Oracle 7.1.4
: version.
: Please respond soon. It's urgent.
: Thank you very much,
: Vinod
Received on Fri May 26 1995 - 00:00:00 CEST