This content has been marked as final.
Show 1 reply
-
1. Re: Virtual procedure store select results in variable
shawkins Jun 26, 2013 7:16 AM (in response to neetacomp)> So can I have multiple select statements in my procedure. If yes, how will it take care of Resultset?
Yes you can. The expectation is that all returnable (the default) statement should match the expected resultset of the procedure if one is defined.
> Can I perform all these things using Virtual procedure?
Yes that should be fine.
> How can I store my first query results in variable myCount?
You would use a scalar subquery:
{code}declare integer myCount = (select count(1) from table1);{code}
Steve