| Converting Forms 6i to 10g [message #319106] |
Fri, 09 May 2008 01:40  |
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 #319325 is a reply to message #319106] |
Fri, 09 May 2008 17:03  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
