Home » Developer & Programmer » Forms » FRM-40735, ORA-06508 (6i, WINXP)
icon5.gif  FRM-40735, ORA-06508 [message #347061] Wed, 10 September 2008 09:48 Go to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Hello,

I am having some difficulty with generating FMX files from my client using Forms 6i on a XP OS. Everytime I create a datablock, even one that simply contains the DUMMY field from dual table, when I go to Program -> Run Form -> Client/Server to generate the .FMX, I immediately receive the error message:
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508. 

Obviously, the form cannot find a package and/or library. I am not attaching any more libraries or packages other than the standard ones that come automatically from TEMPLATE.fmb.

My setup is as follows: I open TEMPLATE.fmb and save a local copy, renamed for the form I am creating. All standard libraries, as far as I can tell, are attached without incident. If I attempt to generate the .FMX at this point, I can do so without receiving the error message. As soon as I create a new datablock and try to run the form, I receive the FRM-40735 error.

The only thing I can think of is that one (or more) of the standard libraries attached to the form is missing and/or invalid. This would not surprise me due to the fact that we do not have a mappable share from server to client so that we can reference standard libraries ($AU_TOP/resource) and standard forms ($AU_TOP/forms). To get around this issue, we copied the libraries and forms down locally to the clients and pointed our FORMS60_PATH registry variable to the local location. I do not like this solution, but am at a loss as to any other alternatives.

At this point, I am recompiling all libraries and forms on the server and attempting to copy down again.

I guess my question is has anyone had this problem before? If so, how did you fix it? Also, is there a way I can tell which package/library is the culprit?

Thank you,
Steve
Re: FRM-40735, ORA-06508 [message #347086 is a reply to message #347061] Wed, 10 September 2008 10:53 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Quick update:

Apparently, this error is not related to the creation of data blocks, but rather when I create a layout. Any canvas that initially or ever references the APPCORE_PROPERTIES window will generate the error message I discussed in my initial post. Now I have a starting place, so I will continue to plunge down this path to see what I can uncover. I believe that my initial hunch is correct and that the library is not valid. I am not sure why though.

-
Steve
Re: FRM-40735, ORA-06508 [message #347087 is a reply to message #347061] Wed, 10 September 2008 10:59 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Unreal. One of the libraries did not get attached. The culprit was OFG4CALL.pll.

As soon as I attached that library, when I compiled the form I noticed that APPCORE and APPTRACE libraries were recompiled.

My problem is now resolved.
Re: FRM-40735, ORA-06508 [message #347141 is a reply to message #347087] Wed, 10 September 2008 19:06 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Glad you have fixed your problem. I would suggest in future using the 'Save As' option of Forms Builder to create your new file. Then after you reopen the form changing the internal name to match the external name.

David
Re: FRM-40735, ORA-06508 [message #386543 is a reply to message #347141] Mon, 16 February 2009 01:52 Go to previous messageGo to next message
GowthamC
Messages: 1
Registered: February 2009
Location: INDIA
Junior Member

Hi,
I am also facing the same problem. i attached OFG4CALL.pll. then also i am facing the same problem. please help me.
Re: FRM-40735, ORA-06508 [message #387070 is a reply to message #386543] Tue, 17 February 2009 18:28 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you tried doing what the Original Poster did?

David
Re: FRM-40735, ORA-06508 [message #404888 is a reply to message #347061] Mon, 25 May 2009 03:56 Go to previous messageGo to next message
zhanghouli
Messages: 1
Registered: May 2009
Junior Member
I am also facing the same problem. I attached all *.pll files, I download all *.pll and *.plxfiles from the EBS Server. I have set FORMS_PATH. The problem occurs, I don't know how to resolve it.
Re: FRM-40735, ORA-06508 [message #404892 is a reply to message #347061] Mon, 25 May 2009 05:42 Go to previous messageGo to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

Hi Aiyaz here,

This is my first project in Forms and i am facing the same problem frm-40375 ON ERROR trigger raised unhandled exception
ORA-06508. Could you please explain me in detail as i am new to this.

Thank you
Re: FRM-40735, ORA-06508 [message #404893 is a reply to message #404892] Mon, 25 May 2009 05:48 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-06508 PL/SQL: could not find program unit being called

Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.
Re: FRM-40735, ORA-06508 [message #406265 is a reply to message #404892] Wed, 03 June 2009 01:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you 'aiyaz_ma' and 'zhanghouli' solved your problems.

David
Re: FRM-40735, ORA-06508 [message #466420 is a reply to message #406265] Mon, 19 July 2010 09:14 Go to previous messageGo to next message
aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad
Member

Thanks David for your concern. I have solved that problem. The error was in the pl/sql package.

Regards
Aiyaz
Re: FRM-40735, ORA-06508 [message #466430 is a reply to message #466420] Mon, 19 July 2010 10:54 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Whoa! Where have you been for the last 13 months?!? Hibernating? Smile
Previous Topic: Inserting multiple selected records into database when click the button
Next Topic: Format for SSN field
Goto Forum:
  


Current Time: Fri Sep 20 06:31:26 CDT 2024