PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Brian H <bridudebri at yahoo dot com>
Subject: results pending problem
Date: Aug 2 1999 4:29PM


The following sybperl code is giving me a error message 
      DB-Library error:
      Attempt to initiate a new SQL Server operation with results 
      pending.

        
        $dbproc->dbcmd("MyStordProc $arg1_int, "$arg2_text\"");
	$dbproc->dbsqlexec;
	while( $dbproc->dbresults != NO_MORE_RESULTS) {
		$dbproc->dbnextrow;
	}
	$sp_status = $dbproc->dbretstatus;
        if ( $sp_status == 0 ) {        # execute sql
        # SQL OK
        } else {
        # SQL Failed
        }
        
        } # IF THEN ELSE

I am running perl 5.004_05 for sun4_solaris and sybperl 2.10.

Any thought or ideas to solve this problem would be great !!!
Thanks,
Brian
_____________________________________________________________
Do You Yahoo!?
Free instant messaging and more at http://messenger.yahoo.com