Can PL/SQL
return multiple values?
am trying to write a stored procedure
or function or something of that
sort which does complex computation and
returns multiple rows of
results. How do I do this? I need to be
able to access this result from
JDBC.
Ans1:
PL/SQL stored procedures or functions only
return single cursor
results. You can circumvent your problem
by creating a stored
function and then calling it in a SQL query.
Ans2:
What about passing back a pl/sql table?