Re: ref cursor

lve wrote:

> 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

Did you trying doing the insert and have it fail or are you just hoping that someone else will do your work for you?

Sorry if this seems harsh ... but your posting makes it look like you didn't even try.

If it fails ... you might want to reference your own words ... "The problem is my stored proc passes a ref cursor". If that is the problem ... change it.

Daniel Morgan Received on Mon May 27 2002 - 11:02:48 CDT