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).
create or replace procedure this_proc (n number) as
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
Click Here to Expand Forum to Full Width