Hello all,
I'm having a problem trying to execute an RPC in DBI using DBI::Sybase. For
some reason, Perl crashes when trying to do an execute() on my statement.
Relevant code is below:
use strict;
use warnings;
require DBI;
my $dbh = DBI->connect("dbi:ODBC:DebitDSN", "myusername", "mypassword");
my $sth = $dbh->prepare(q!EXECUTE FRPC "transaction_name",
@ENTR_ID="xxxxxxxxxxxxxxxx"!);
$sth->execute;
A couple of oddities I've noticed about this:
- If I enable tracing, the script will *not* crash - but only if I have
tracing set at level 4 or higher.
- If I perform a normal SELECT on a view in this database, I have no
problems and can pull data fine. Apparently, DBI has something against this
RPC. :( Unfortunately, what I need to do can only be done by executing this RPC
- a normal SELECT won't work.
Any ideas?
JC
________________________________
-----------------------------------------------------------------------
This e-mail is intended for the addressee shown.
It contains information that is confidential and
protected from disclosure. Any review, dissemination
or use of this transmission or its contents by persons
or unauthorized employees of the intended organizations
is strictly prohibited.
The contents of this email do not necessarily represent
the views or policies of PSCU Financial Services.
