Yes, I'm an idiot - I'm using DBD::ODBC, not DBD::Sybase. But it still crashes. :)
-----Original Message----- From: John Cantu Sent: Wednesday, April 08, 2009 1:14 PM To: '[email protected]' Subject: Perl crashing with DBD::Sybase 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. ----------------------------------------------------------------------- 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.
