Home » Developer & Programmer » Forms » Converting Forms 6i to 10g (Oracle DS 10g)
Converting Forms 6i to 10g [message #319106] Fri, 09 May 2008 01:40 Go to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Hi all,
I want to convert my forms6i to DS 10g. but i am getting the error at runtime in 10g
( FRM-40735 - on error trigger raised unhandled exception
ora-06508)
What will be the problem? please tell me.

Regards,
Kalyan
Re: Converting Forms 6i to 10g [message #319115 is a reply to message #319106] Fri, 09 May 2008 02:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Post your code. Have you converted the database yet? Have you signed on?

David
icon7.gif  Re: Converting Forms 6i to 10g [message #319116 is a reply to message #319106] Fri, 09 May 2008 02:01 Go to previous messageGo to next message
mxeeshan
Messages: 7
Registered: May 2008
Junior Member
Is there any library attached to the form? if so then first compile that library seperatly on form 10g developer, remove and attach the library again to the form.Smile
Re: Converting Forms 6i to 10g [message #319133 is a reply to message #319116] Fri, 09 May 2008 02:23 Go to previous messageGo to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

yes, i am using attached PLSQL Lib. ok i will compile and try that. thank u.
Re: Converting Forms 6i to 10g [message #319325 is a reply to message #319106] Fri, 09 May 2008 17:03 Go to previous message
psteve
Messages: 9
Registered: March 2005
Location: New England
Junior Member
Frist use google to identify the underlying error:

I find:

ORA-06508: PL/SQL: could not find program unit being called.

With this error, if it were my code, I would put a breakpoint at the top of the trigger that has the error, then I would get in the debugger and single step through the trigger until the error happens. By looking at the exact statement throwing the error, I might then know which program unit is missing (I say 'might' because in Forms, things happen in indirect ways---for example, maybe the missing program unit is in the definition of a view that a block is based on). However, knowing the statement almost always reveals the underlying cause.

Here are some possibilities
--a package was not created in the DB
--a package was created, but it needs a grant
--a library was not attached to the form
--a function is flat-out missing from the form--perhaps it needs to be subclassed from somewhere
--there is an error in the code and it does not have the name of the program unit right
--you did not logon to the database
--you logged on, but used the wrong account

Moral: If you do not know how to use the debugger, learn ASAP

BTW, if you do not know which tirgger has the error, then put the breakpoint in the pre-form or when-new-form-instance trigger and just single step through all the triggers.
Previous Topic: Sql return very slowly why ?
Next Topic: HOW TO INSTALL FORM & REPORT BUILDER 6i
Goto Forum:
  


Current Time: Fri Dec 09 02:12:19 CST 2016

Total time taken to generate the page: 0.12955 seconds