Re: Capturing a value returned from a stored procedure

Fetch the value from the $sth the same way you'd fetch any results from a statement handle, e.g. $sth->fetch and friends.

Comment on Re: Capturing a value returned from a stored procedure

Replies are listed 'Best First'.
Re^2: Capturing a value returned from a stored procedure by punkish (Priest) on Dec 21, 2004 at 00:01 UTC
Thanks for you quick response... Fetch the value from the $sth the same way you'd fetch any results from a statement handle, e.g. $sth->fetch and friends. Unfortunately, that gives me the error `DBD::ODBC::st fetch failed: (DBD: no select statement currently execut +ing err=-1) at ...` [download] is that because SELECT is not my last statement? The entire stored proc is a number of statements (40 or so). The stored proc is ended with a COMMIT TRAN. Seems like RETURN @id is not the way to do this.	[reply] [d/l]

Replies are listed 'Best First'.

Fetch the value from the $sth the same way you'd fetch any results from a statement handle, e.g. $sth->fetch and friends.

Unfortunately, that gives me the error

DBD::ODBC::st fetch failed: (DBD: no select statement currently execut
+ing err=-1) at ...
[download]