Certainly use trace(). Maybe use more generous buffer sizes.
Tim.
On Wed, Sep 26, 2001 at 04:09:30PM -0500, Jones Robert Contr 81 CS/SCK wrote:
Trying to get output from a procedure call. Definitely being a pain. Yes,
yes, I've looked at perldoc DBD::Oracle and that didn't seem to work.
Trying to get output from a procedure call. Definitely being a pain. Yes,
yes, I've looked at perldoc DBD::Oracle and that didn't seem to work. I've
even read up on perldoc.com about DBI, and various other websites. Running
out of options.
stats: Windows NT client/server with Oracle 8.1.5
From: Jones Robert Contr 81 CS/SCK
$dbh=DBI-connect($data, $login, $pw) || die $dbh-errstr\n;
$dbh-errstr\n;
END;) || die $dbh-errstr\n;
Probably not related to your specific problem, but:
Putting $dbh-errstr inside quotes is wrong. Double
quotes will interpolate variables, but
calls. And if you're going to die on any error anyway,
you may as well put {RaiseError=1} in the connect and
save yourself from all those '|| die ...' clauses.
And I forgot to mention, that you're not currently checking
the status of the bind_param or execute statements, so
RaiseError might