| error in on-error trigger after database upgraded from 9.2.0.8.0 to 10.2.0.1.0 [message #451281] |
Tue, 13 April 2010 07:34  |
shashikoor
Messages: 25
Registered: April 2006
Location: india
|
Junior Member |
|
|
hi,
Greetings...
Recently we have upgraded our oracle data base to 10.2.0.1.0 from 9.2.0.8.0.
We are using an application developed on forms 6i which interacts with the database.
While we are saving the changes done in of the forms , we are getting an error in frm-40735 : ON-ERROR trigger raised un handled exception ORA-06508.
I tried to debug it in the fmb. The error was coming when the commit_form is issued.
Is this error because of upgradation to 10g. We are not getting this error in other databases where the oracle version is 9.2.0.8.0.
Can you please help ?
Thanks,
shashanka.
|
|
|
|
| Re: error in on-error trigger after database upgraded from 9.2.0.8.0 to 10.2.0.1.0 [message #451284 is a reply to message #451281] |
Tue, 13 April 2010 07:40  |
 |
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
What "program unit" is missing? Did you "forget" to migrate some stored procedures?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
