Hello,
I have written a stored procedure which will give me
total count of records plus number of records as per
my conditional criteria, but returns as setof records.
So to access count i have to iterate through
resultset, in java. So is there any way, to access
count once n setof records using resultset. Can I have
two OUT parameter, one as Integer n other as record in
single procedure.
Or at java side, can acces count before iterating
resultset only once. Remaining records as usual by
iterating resuleset.
Thanx,
Manisha
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/