Re: Stored Procedure using perl



khandelwal.amit@xxxxxxxxx wrote:
> 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.

You probably have AutoCommit turned off. Turn it back on and things
should work normally.

Michael

.



Relevant Pages

  • Re: Need help with Perl and MySQL database data load
    ... You are telling Perl that you're creating a package named ... > 'MySQL' with this line. ... I get the error message "Can't locate object method "connect" ... When I put that line, use DBI;, back in I then get an authentication ...
    (comp.lang.perl.misc)
  • Had to create DBD::mysql::dr::imp_data_size unexpectedly
    ... I am experiencing a strange error with DBI. ... Use of uninitialized value in subroutine entry at ... Does anybody know what causes that error message to be printed? ... Output of perl -V ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... T> expected a mature library like DBI to behave like this. ... I learned plenty about the perl side of things from her posts. ... closely represent the SQL idea of a null. ... trivially easy to perform bulk loads using the DB's particular ...
    (comp.lang.perl.misc)