This is the first time I've tried using Apex's Data Loading page creation wizard to load external files into an Oracle table. I'm consistently getting the above error when it's actually trying to load the data into the table. I get through the column mapping just fine (there are about a dozen columns). Then it churns for a while and returns:
ORA-01000: maximum open cursors exceededORA-01000: maximum open cursors exceeded
(Yes, it actually shows the error twice.)
The tab-separated file has 14k rows and is 1.3MB in size.
I've granted SELECT, INSERT, UPDATE, DELETE access on the table to the Apex schema the application runs from. The fact that it offered this table in the drop-down list of possible tables to load from tells me I have the permissions right.
I've checked our database and the open cursor limit is 2,048.
Any suggestions?
Thanks,
Stew