Stored Procedure using perl
- From: khandelwal.amit@xxxxxxxxx
- Date: 9 Nov 2005 07:56:31 -0800
I am trying to execute a stored procedure in Sybase database using perl
DBI and I am getting the following error message.
DBD::Sybase::st execute failed: Server message number=226 severity=16
state=1 line=49 server=xxxxxxx procedure=sp_get text=SELECT INTO
command not allowed within multi-statement transaction.
Server message number=208 severity=16 state=6 line=92 server=xxxxxxxx
1 procedure=sp_get text=#option not found. Specify owner.objectname or
use sp_help to check whether the object exists (sp_help may produce
lots of output).
$cmd = " exec sp_get '', '$my_secy_id', '', '','','', '', '','US'";
$cmd = "exec sp_get \@ticker='IBM-MD', \@filter='US'";
$cmd = "BEGIN exec sp_get \@ticker='IBM', \@filter='US' END";
my $sth_op = $d_dbh->prepare($cmd);
$sth_op->execute()
These are some of commands I tried. Any suggestions.
Thanks,
Amit Khandelwal
.
- Follow-Ups:
- Re: Stored Procedure using perl
- From: michael . peppler
- Re: Stored Procedure using perl
- Prev by Date: RE: Executing PL/SQL packages in Perl
- Next by Date: Re: DBD DBI Problem
- Previous by thread: DBD DBI Problem
- Next by thread: Re: Stored Procedure using perl
- Index(es):
Relevant Pages
|
