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

  • From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
  • To: shastry17@xxxxxxxxx
  • Date: Mon, 19 Mar 2007 08:54:55 -0700 (PDT)

$ 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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx; ora-apps-dba@xxxxxxxxxxxxx
Cc: Jurijs Veļikanovs <J.Velikanovs@xxxxxxxx>; Jurijs Velikanovs 
<j.velikanovs@xxxxxxxxx>
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

Other related posts: