Re: "FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06508"

Hello all,

Thanks for Nigel and Kathy for your fruitful suggestion. I compiled the schema and bounced the server, the FRM- error was resolved.

Regards,
Anand Rag

On 3/19/07, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> wrote:
>
> $ oerr ora 6508
> 06508, 00000, "PL/SQL: could not find program unit being called"
> // *Cause:
> // *Action:
> Rag, I guess your form is trying to call a procedure or function that is
> no longer present (or accessible). Probably it's a missing program unit on
> the database - but I suppose it could be a missing client side program unit.
>
> 1) do you have the source of the form? if so, try recompiling it: the
> Forms compiler should tell you what is missing
> 2) try running it in debug mode
> 3) try tracing its execution on the server
> 4) oh, and check you are connecting to the correct schema in the first
> place...
>
> This should be easy to find, as W-N-F-I happens as you open the form.
>
> What version of everything?
>
> Regards Nigel
>
> ----- Original Message ----
> From: Anand <shastry17_at_gmail.com>
> To: oracle-l_at_freelists.org; ora-apps-dba_at_freelists.org
> Cc: Jurijs Veļikanovs <J.Velikanovs_at_alise.lv>; Jurijs Velikanovs <
> j.velikanovs_at_gmail.com>
> Sent: Monday, March 19, 2007 2:20:28 PM
> Subject: "FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled
> exception ORA-06508"
>
> I have the below error when I was accessing the form Data Maintenance.
>
> "FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception
> ORA-06508"
>
> Could anyone please help me out on this?.
>
> Thanks in advance.
> Rag
>
>

--
http://www.freelists.org/webpage/oracle-l