>
> Dear DBAs !
> I need to write a stored proc that will do the following :
> -- open a cursor ;
> -- loop over the rows returned by the cursor ,
> filter out some of the rows that do not match a certain criteria ,
> do some processing on other rows (that match the criteria)
Audrey:
What you want is a cursor variable. A cursor variable references a cursor
object and may refer to different SQL statements at different times. In your
case, the most important benefit of the cursor variable would be that it
provides a mechanism for passing results of queries (the rows ret
hi Andrew,
consider using a array (pl/sql table) as a return
datatype of your function. Inside the function open ur
cursor and populate that set of rows u wanna return
into the return datatype.. which would be an array in
this case. note that u must define a global array in
some package first so