On 02/04/2004 06:09 PM, Michael Cesar wrote:
Thanks a million...
"BTW, if you are really putting the SELECT text in the script,
prepare()ing a SELECT by itself and executing that would be more
efficient and avoids having a cursor returned from a package."
Why is this so? My DBA wants everything
On 02/04/2004 12:55 PM, Michael Cesar wrote:
Heres the entire script.
Michael Cesar
#!/usr/local/bin/perl -w
use strict;
use DBI;
use Data::Dumper;
use DBD::Oracle qw(:ora_types);
my (@result_arref,@row);
my $dbh = DBI->connect(
'dbi:Oracle:XXX',
'abc',
'***
On 02/04/2004 06:56 AM, Michael Cesar wrote:
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help.
I have an Oracle DBA I need to work with who doesn't seem to how to
write PL/SQL for Perl DBI. He insists on writting stored procedures
which lo
Tim,
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help. I have an Oracle
DBA I need to work with who doesn't seem to how to write PL/SQL for Perl DBI. He
insists on writting stored procedures which loop through the results set
fetching