Hi
All,
I want to
set this environment on so that anything that the store procedure spits out will
show during the debug process within Perl DBI connection. Can someone
please show me how I can set this?
$dbh->do("SET SERVEROUTPUT ON");
Not
working. Please help.
Peter
'SET SERVEROUTPUT ON' is a SQL*Plus command to enable DBMS_OUTPUT buffering.
To do the same thing under DBI/DBD::Oracle, use the DBI func() method. Run
'perldoc DBD::Oracle' and read the section that starts with
'dbms_output_enable / dbms_output_put / dbms_output_ge
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 environme
();
$sth->finish;
foreach ($dbh->func('dbms_output_get')) {
print "$_\n"; }
$dbh->disconnect();
exit;
-Original Message-From: Loo, Peter # PHX
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001 1:02
PMTo: [EMAIL PROTECTED]Su
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 an
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".
x27; );
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-U