Hello all,

I research numerous TARs at Metalink on this subject
and have increased the open_cursor parameter in
init.ora to 800, which did not help the problem. I am
trying to load about 1 MB of data via a frontend Java
application to the database. All the necessary
rs.close() and ps.close() statements are included in
the Java loader to close any open cursor objects, so I
don't think the problem is with the frontend.

When I issue a "Select count(*) From v$open_cursor",
it returns 800 - the open_cursor number in init.ora. I
wrote a PL/SQL program to diagnose ora-01000, and it
returned these results...

Cursor number is 1
text: SELECT ID FROM Probe WHERE Name =: "SYS_B_0"
Cursor number is 2
text: SELECT ID FROM Probe WHERE NAME =: "SYS_B_O"
Cursor number is 3
text: SELECT ID FROM Probe WHERE Name =: "SYS_B_0"
Cursor number is 4
text: SELECT ID FROM Probe WHERE NAME =: "SYS_B_O"
etc..
- the same all the way through cursor number 23, where
it stops printing the results. By the way, the Probe
table has 800 unique names that were inserted, but the
name "SYS_B_0" is NOT one of them. Does SYS_B_0 have
to do with System in Oracle?

I greatly appreciate any suggestions or comments.

Michael


=====
Michael Honig
Senior Database Developer/Analyst
Weill Medical College of Cornell University
Dept. of Microbiology & Immunology
1300 York Avenue, Box 62
New York, NY 10021
email: [Email Address Removed] [off] 212-746-0408; WTC-RIP

__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
Oracle LazyDBA home page