Too many cursors open??

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