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
