Re: SQLFORMS 3.0 Error

From: James Forgy <forgy_at_ll.mit.edu>
Date: Thu, 10 Mar 94 11:04:23 -0500
Message-ID: <9403101104.PN26719_at_LL.MIT.EDU>


In article <19940307.091240.749_at_almaden.ibm.com> smith_at_vnet.IBM.COM writes:
>From: smith_at_vnet.IBM.COM
>Date: Sun, 6 Mar 94 14:04:31 EST
>Subject: SQLFORMS 3.0 Error
 

>Very randomly, users are getting the following error message when they
>run a SQLFORMS 3.0 program: FRM-40734:PL_SQL error - internal PL/SQL
> error occurred.
>The manual simply states that a fatal error occurred in PL/SQL during
>trigger execution, and that the user should contact the DBA. Well, as it
>turns out, I am the DBA/Programmer, and I have no idea what this error means,
>or what to look for. Has anyone else encountered this message? Any hints
>would be greatly appreciated.
 

>Reply-To: smith_at_vnet.ibm.com
>Organization: IBM Canada
>Disclaimer: This posting represents the poster's views, not those of IBM
>News-Software: Usenet 3.1
>X-X-From: smith_at_vnet.ibm.com (Scott Smith)
>X-Spool-Tags: no

explore the options parameters in the runform comand to disable array processing, sharing cursors etc... increase the max_open_cursors parameter in init.ora and maybe the context_area parameter. This might work.

Your form is running out of memory or cursors.

The best thing to do, if you can, is call Oracle,

jf Received on Thu Mar 10 1994 - 17:04:23 CET

Original text of this message