Home » SQL & PL/SQL » SQL & PL/SQL » Oracle error (9.0.4.0)
Oracle error [message #314883] Fri, 18 April 2008 02:47 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,
when I am executing the view am getting the following error.Pls give me any idea to resolve this.
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: Step-6:DDL Event Security. 
You are not permitted to perform the requested structural changes to scott.V_TEST_CASE (VIEW)
Event triggered : CREATE
ora_login_user (session_user) : SCOTT (SCOTT)
Search :  select count(*) from diy_secure_ddl_tab where obj_name like '%\%%' escape '\' and obj_type = 'VIEW' and obj_type = 'USER' and ( event_CREATE = 'Y'       or status = 'Override')
---
ORA-06512: at line 162
ORA-06510: PL/SQL: unhandled user-

Thank you.

Re: Oracle error [message #314884 is a reply to message #314883] Fri, 18 April 2008 02:58 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
1. You don't execute views, I will assume that what you mean is that you selected from the view.
Show us the code that you executed that raised the error.
Re: Oracle error [message #314885 is a reply to message #314883] Fri, 18 April 2008 03:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ORA-20001

This is a user defined exception number, probably caused by a ddl-trigger.

[Edit: Seeing pablolee's reply: I think this happened when the original poster tried to (re)define the view]

[Updated on: Fri, 18 April 2008 03:03]

Report message to a moderator

Re: Oracle error [message #314886 is a reply to message #314885] Fri, 18 April 2008 03:07 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Quote:
I think this happened when the original poster tried to (re)define the view
I am sure that you are right Frank, (I kinda figured that too, I was trying to be obtuse, didn't work) Anyway, I would still like the same thing from the OP i.e. the statement that caused the error (That way we can get the OP to work their way through the troubleshooting steps)
Re: Oracle error [message #314887 is a reply to message #314886] Fri, 18 April 2008 03:12 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
bummer.. Not only understood you being obtuse, but also not understanding what the .. obtuse is Very Happy


Dictionary.. ah.

The Socratic approach..
Re: Oracle error [message #314894 is a reply to message #314887] Fri, 18 April 2008 03:45 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
LOL, cheers for the laugh. (Been up since 4am working, needed a laugh Very Happy )
Previous Topic: Read config values from sql script
Next Topic: how can i create a trigger
Goto Forum:
  


Current Time: Sun Dec 11 08:06:03 CST 2016

Total time taken to generate the page: 0.06311 seconds