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: salvatore dot sferrazza at BANKERSTRUST dot COM
Subject: Re: results pending error
Date: May 6 1998 5:41PM

are you doing something like:


dbcmd($dbproc, "SELECT table FROM tables");
dbsqlexec($dbproc);
dbresults($dbproc);

while (@ret = &dbnextrow($dbproc)) {

     &drop_table($dbproc, @ret[0]);

}

???

if you are the problem is that your first dbproc is already ties up in the
SELECT and can't be used at this time.
open up a new dbproc in your drop_table sub.

I also hope there is a good reason you are still using perl 4.

HTH,

Sal