Re: Too many cursors open??

No,

Not even that it's just a simple table, primary key index contains one field and it concerns about 6000 records. Nothing fancy there.

Oh, it is Oracle 7.1, OS NT 3.51(not that I think that should be the problem.)

The sun, the sea, the sand,
Tony van der Prijt

>

On 11 Sep 1996 23:58:07 GMT, msabbey_at_magi.com wrote:

>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 Fri Sep 13 1996 - 00:00:00 CEST