Home » SQL & PL/SQL » SQL & PL/SQL » error 04063 creating view
error 04063 creating view [message #652497] Fri, 10 June 2016 09:40 Go to next message
Messages: 3
Registered: June 2016
Junior Member
Query is execute ok, but if I try to make a view is showing: error 04063. How to fix it?
Re: error 04063 creating view [message #652498 is a reply to message #652497] Fri, 10 June 2016 09:42 Go to previous messageGo to next message
John Watson
Messages: 8704
Registered: January 2010
Location: Global Village
Senior Member
How to fix it?
You need to debug the code. Since only you have seen it, you are on your own Smile
Re: error 04063 creating view [message #652499 is a reply to message #652497] Fri, 10 June 2016 09:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.
Re: error 04063 creating view [message #652508 is a reply to message #652497] Fri, 10 June 2016 17:31 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
There are a lot of possibilities. A common problem is that, likes procedures and functions, privileges granted through roles do not apply to views. So, a query might run fine with some role privileges, but the same query in a view would not execute, because the privileges need to be granted explicitly, not through a role. To test if this is the problem, you can try SET ROLE NONE and then see if the query by itself still executes If not, then that is the problem. If you created the view using force, you should also remove the force keyword to see what errors that produces or if the view can even be created.

Previous Topic: Listing individual average price
Next Topic: Query that gives many different values
Goto Forum:

Current Time: Sun May 22 11:47:11 CDT 2022