sybperl-l Archive

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