| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help please! ORA-604 Max Cursors Exceeded problem
A copy of this was sent to "Wicksey" <Wicksey_at_hotmail.com>
(if that email address didn't require changing)
On 8 Mar 1999 16:41:34 GMT, you wrote:
>Hi people,
>
>I'm using Forms 4.5 and accessing a Pro*C dll using ORA_FFI. My problem is
>thus:
>
>When running my application, I keep getting an error either in the log file
>of the dll or as an exception in forms 4.5 - both are to do with Max
>Cursors being exceeded. I thought that Forms Cursor loops implicitly
>closed cursors - does anyone know what the problem could be?
>
>I've checked out my Initorcl.ora file and can find no reference to
>open_cursors - can anyone help me please?
>
>Thanks in advance,
>
>Nick
Just add:
open_cursors = 250
to your init$ORACLE_SID.ora and restart the database.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |