Up Prev Next
From: "Klein, Shoshana R" <Shoshana dot Klein at gs dot com>
Subject: executing a stored procedure with 2 sql statements and returning the final resultset
Date: Oct 25 2000 12:13AM
Is there a way of executing a stored procedure with 2 sql statements and
only returning the final resultset to my perl script.
For instance, if I want to select * into temp-tbl from sysusers where name
like xyz and then
select * from temp-tbl where x=myprof
So far I've only been successful with 1 sql statement returning 1 resultset.