Re: Too many cursors open??

Are there any triggers on the table you are trying to creat a record in??

Michael

pecotpt_at_pi.net (Tony van der Prijt) wrote:

>Hi there,
 

>I'm wondering if someone could give me a hint about this one:
 

>What I want to do is insert records into one table from a selection
>from a different table. At first I used the following syntax:
 

>INSERT INTO table_dest ( td_field1)
> SELECT ts_field1
> FROM table_source;
 

>This did not work. Oracle responded with the message that I had to
>many cursors open. At that time I was the only user and I should be
>able to have up to 200 open cursors.
 

>I did work around the problem by defining a cursor and looping through
>the result set and inserting records separately, but I'm curious: Does
>anybody know why my initial statement refused to execute? I sure
>don't.
 

>Any comments are welcome.
 

>The sun, the sea, the sand,
>Tony van der Prijt
Received on Wed Sep 11 1996 - 00:00:00 CEST