Up Prev Next
From: "Wechsler, Steven M" <WechslerSM at bernstein dot com>
Subject: getting status from multiple-statement transaction
Date: Feb 8 1999 7:09PM
If I understand it correctly, with DB-Library, $dbh->dbretstatus will return
the exit status of a stored procedure.
However, what happens if a multiple-statement batch is sent as one
How can I determine the exit status of the sp_firstproc statement?
According to the docs, you can only call dbhasretstat after dbresults
returns NO_MORE_RESULTS, but, to my understanding, this will occur *only*
after all results have been processed.
Steve Wechsler/Senior DB Administrator/Sanford C. Bernstein & Co.
"Never underestimate the power of human stupidity" - Lazarus Long
Support the Anti-SPAM amendment: http://www.cauce.org