If you are trying to get output from a stored procedure, use something like:
#enable output $dbh->func( 1000000, 'dbms_output_enable' ); #execute proc $sp my $sth=$dbh->prepare($sp); $sth->execute(); #retrieve output my @text = $dbh->func( 'dbms_output_get' ); and @text contains what would have been printed in your SQLPLUS session with "SET SERVEROUTPUT ON" perldoc DBD::Oracle for more details -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 August 2004 10:58 PM To: Tran, Dong D [IBM GS]; DBI-Users Subject: Re: set serveroutput on On 08/03/2004 12:56 AM, Tran, Dong D [IBM GS] said: > Is it possible from me to have the example of "SET SERVEROUTPUT ON" in Perl? I am not the sole source of all wisdom. Questions like this should be asked at [EMAIL PROTECTED], not directly to me. If you are asking about DBI, the answer is no. SET is not SQL, it is a SQL*Plus command. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Cthulhu in 2004. Don't settle for the lesser evil. Australia Post is committed to providing our customers with excellent service. If we can assist you in any way please telephone 13 13 18 or visit our website www.auspost.com.au. CAUTION This e-mail and any files transmitted with it are privileged and confidential information intended for the use of the addressee. The confidentiality and/or privilege in this e-mail is not waived, lost or destroyed if it has been transmitted to you in error. If you have received this e-mail in error you must (a) not disseminate, copy or take any action in reliance on it; (b) please notify Australia Post immediately by return e-mail to the sender; and (c) please delete the original e-mail.
