Perl Error

Hello,

I am trying to execute a procedure in perlscript from MSSQL server database.I am using CYGWIN console for executing the perl script. The DBI 1.28 is being used with perl5.8.7 here.s

Sample code:

my $sth = $dbh->prepare("{ call $VIOLATIONS_SP }");
$sth->trace(15);
$sth->execute() || die $sth->errstr;
$sth->finish();

I get the following error/trace. The execution breaks in between.
=================================================

01000 [Microsoft][ODBC SQL Server Driver][SQL Server]exec GetPosValueViolations
506, 505
Numfields == 0, SQLNumResultCols == 0
Numfields == 0, SQLMoreResults == -1
dbd_describe sql 678435632: num_fields=0
dbd_describe skipped (no result cols) (sql f678435632)
dbd_st_execute got no rows: resetting ACTIVE, moreResults
<- execute= -1 at ./wtcustom.pl line 121
-> finish for DBD::ODBC::st (DBI::st=HASH(0x10168c48)~0x1015f43c)
<- finish= 1 at ./wtcustom.pl line 122
======================================================

The procedure being executed contains reference of around 45 procedure in it. And some of them have cursors implemented in them.
Is it that some truncation is happening as the cursors are fetching around 1-2 lakhs of rows sometimes.

Is there any workaround to overcome this problem.


Any help will be graetly appreciated..

SuSon

Relevant Pages

  • Re: DBI error handling
    ... > I've a perl script which inserts data to a database. ... You could also check the return value of the execute() method. ... of "execute" (and most other DBI methods) for errors if you're not using ... "A teacher is never a giver of truth - he is a guide, a pointer to the truth that each student must find for himself. ...
    (comp.lang.perl.misc)
  • Exec SP with Cursors using ADO
    ... I am trying to execute an SP which contains cursors etc....but when I create ... the RS using ADO, I seem to get an error? ... 'Creates Command information ...
    (microsoft.public.vb.com)
  • Cursors with ADO
    ... I am trying to execute an SP which contains cursors etc....but when I create ... the RS using ADO, I seem to get an error? ... 'Creates Command information ...
    (microsoft.public.vb.database.ado)
  • FW: Lost the capacity to get paramters
    ... I installed a new machine with CENTOS 5 64 Bits and DBI 1.604, later svn, ... I execute this perl script ... Is it DBD or DBI or Perl? ...
    (perl.dbi.users)
  • Re: trigger- problem: too many open cursors
    ... cursors are explicit cursors you've coded. ... Oracle can open additional ... execute an update on this Table Table1, ...
    (comp.databases.oracle.misc)