ref cursor

Can the rows from ref cursor be inserted into a permanent table as set-something like the following:

insert into tableA
select * from refcursor

The problem is my stored proc passes a ref cursor as an output parameter. I need to insert those rows(from the ref cursor) into a table as a set. The ref cursor may return thousands of rows.

lve Received on Sun May 26 2002 - 08:23:51 CDT