-
hi,
wondering if there's anyway to set serveroutput on or something similar with a procedure ? i want to be able to
dbms_output.put_line without having to rely on the user to
issue set serveroutput on (i know it can be done w/ login on each individual client -> trying to avoid this).
thanks!
create or replace procedure this_proc (n number) as
<>
begin
<>
end;
-
no because that is a SQL*PLUS command not an SQL command
you can put serverout put on in login.sql but that will enable serveroutput by default in the client
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|