Re: Invalid Cursor Error

From: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Tue, 21 Apr 1998 20:54:59 GMT
Message-ID: <353a68c3.48093454@news.demon.co.uk>

On Sun, 19 Apr 1998 18:19:57 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>A copy of this was sent to eric_at_deptj.demon.co.uk (Eric Junkermann)
>(if that email address didn't require changing)
>On Sat, 18 Apr 1998 16:46:53 GMT, you wrote:
>
>>We have the following as type 2 dynamic SQL:
>>
>>insert into my_table (date_field, other_field)
>>select sysdate, other_field from my_table
>>where rowid = :bind_variable
>>;
>>
>
>I don't know why it would get this. Can you share the code with us?

There isn't really any more (just a few more columns).
> I tried:

I think perhaps the insert .. select (from the same table), which you didn't try, has got something to do with it.

BTW I'm just looking for understanding here, not a solution.

Eric Received on Tue Apr 21 1998 - 15:54:59 CDT