set client env with from procedure ?

[adrock]

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;

[pando]

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