Say you return a refcursor called return_cursor
select myfunction(your_in_array); fetch all from return_cursor;
If you are calling from a development environment, you put the return value of the fuction (the refcursor name) into a variable, then dynamicly build the fetch
all statement from return value of the function. This must be done in the context of a transaction, i.e. both statements must must be executed in the same transaction.
The refcursors work really well and are very flexible.
Relyea, Mike wrote:
Thanks for the input. This looks very promising. I have one further
question. My SQL statement is going to pull data from more than one
table in a relatively complex query. How do I cast the RETURNS portion
of the function? Again, I can't find what I'm looking for in the docs.
I've included an actual sample SQL statement. I will only be changing
the first portion of the WHERE clause.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
