Re: Help please! ORA-604 Max Cursors Exceeded problem

Forms cursor loops do implicitly close themselves depending on how you define your loop.

e.g

       for data in c_cursor loop
                    ..
                    ..
        end loop;

will implicitly close the cursor.

      open c1;
      while c1%found loop
                    ..
                    ..
      end loop;
      close c1;

In this instance you have to close the cursor yourself.

Mark

Wicksey wrote in message <01be6982$82f1eb30$0159ea9e_at_mothergoose>...
>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
Received on Tue Mar 09 1999 - 02:53:49 CST