Home » Developer & Programmer » Forms » FRM-40735 ON -ERROR trigger raised unhandled exception ORA-04063 (10g,Sun OS)
FRM-40735 ON -ERROR trigger raised unhandled exception ORA-04063 [message #414486] Wed, 22 July 2009 06:11 Go to next message
Messages: 58
Registered: February 2009
Hi all

We refreshed a database yesterday and we recompiled the objects too.

From application side they are getting error like "FRM-40735 ON -ERROR trigger raised unhandled exception ORA-04063".

Can you please explain me where the problem is.

Re: FRM-40735 ON -ERROR trigger raised unhandled exception ORA-04063 [message #414489 is a reply to message #414486] Wed, 22 July 2009 06:19 Go to previous message
Messages: 21130
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Recompile once again:
ORA-04063: %s has errors

Cause: Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view's defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types.

Action: Fix the errors and/or create referenced objects as necessary.

[Updated on: Wed, 22 July 2009 06:19]

Report message to a moderator

Previous Topic: how to set constant value for an item in form
Next Topic: Character mode Reports in Oracle Reports 10g
Goto Forum:

Current Time: Tue Jul 25 04:16:05 CDT 2017

Total time taken to generate the page: 0.05356 seconds