Re: ORA-01000: maximum open cursors exceeded

• Post for FREE via your newsreader at post.usenet.com ****

Not as far as I know ... the application code is handled by another group. The strange thing is that the app was running just fine on another machine, no problems...

DA Morgan wrote:

> vinnie washington wrote:

>> I'm wondering if anyone can help me figure out why I'm receiving this
>> problem. I am running Oracle 8.1.7 on Win2K server and have been
>> receiving this message in my application. When I query 'select
>> sql_text from v$open_cursor; ' to see what is holding things up, I
>> see:
>>
>> SELECT NULL AS table_cat, t.owner AS table_schem,
>>
>> with 300 entries in the table. Any thoughts?

> Not using bind variables?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=