Re: Stored procedures and Forms

Xavier Costey wrote:

> Hi my name is Xavier Costey and I´ve a problem:
>
> I program with Oracle Forms Ver 5.
> I assign a stored procedure to a Data Block. This runs well,
> but when the program is executed the number times of the variable
> OPEN_CURSORS
> then forms raises with the error number ORA-01000.
>
> Questions:
>
> - The forms close automaticly the cursor? If Forms don't close the
> cursor how can i close it?
>
> - The package of the stored procedure is correct ?
>
> - I´ve got teh variable OPEN_CURSORS = 512, is this value correct?
>
> Thanks
>
> ORA-01000 : maximum open cursors exceeded
> A host language program attempted to open too many cursors. The
> initialization parameter OPEN_CURSORS determines the maximum
> number of
> cursors per user.
>

<snip>

I had this problem and Oracle Support told me that, despite the description in the Forms help, the use of ref cursors is not supported in this way. You need to replace your ref cursors with PL/SQL tables.

If you have any further questions regarding this feel free to email me.

HTH
Geoff Received on Thu May 13 1999 - 21:12:06 CDT