Re: set serveroutput on

2004-08-03 Thread Michael A Chase
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.

Re: set serveroutput on

2004-08-03 Thread Ravi Kongara
There two ways to set SERVEROUTPUT ON in Perl. 1) Using HERE docs ex: $sqlcmd=sqlplus -s $user/[EMAIL PROTECTED] EOF /dev/null\n . set echo off\n. set verify off\n. set feedback off\n. set heading off\n. set conca off\n. set pagesize 0\n. set newpage 0\n. set

RE: set serveroutput on

2004-08-03 Thread Fox, Michael
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

RE: SET SERVEROUTPUT ON

2001-02-20 Thread Mitchell, Louise M
It's this: $dbh-func(dbms_output_enable); Regards, L -Original Message-From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001 12:02 PMTo: [EMAIL PROTECTED]Subject: SET SERVEROUTPUT ON Hi All, I want to set this environment on so

RE: SET SERVEROUTPUT ON

2001-02-20 Thread Loo, Peter # PHX
Hi all, Just wanted to thank everyone who helped shed light for me. It worked out great in my test program below so I will add it to my production program now. Thanks a bunch. #!/usr/bin/perl use DBI; $ENVR = cwd() =~ /devl/ ? "devl" : "prod"; require