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.