Home » SQL & PL/SQL » SQL & PL/SQL » Creating procedure dynamically-Insufficient privilages (Oracle 10g)
Creating procedure dynamically-Insufficient privilages [message #409845] Wed, 24 June 2009 04:18 Go to next message
anakin
Messages: 13
Registered: May 2009
Junior Member
I have to create a stored procedure dynamically. But while doing Execute Immediate it is throwing an error.
ORA-01031: insufficient privileges
Please suggest me how to solve this problem?

Re: Creating procedure dynamically-Insufficient privilages [message #409848 is a reply to message #409845] Wed, 24 June 2009 04:25 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Quote:
ORA-01031: insufficient privileges


Self explaining error message.
Please post what you did with error message you get by following forum guidelines.

regards,
Delna
Re: Creating procedure dynamically-Insufficient privilages [message #409851 is a reply to message #409848] Wed, 24 June 2009 04:28 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I advise against the creation of objects through PL/SQL without further questions. Do you really need to create objects on the fly through PL/SQL?

Looks like a classic role + procedure problem. Wink

MHE
Re: Creating procedure dynamically-Insufficient privilages [message #409853 is a reply to message #409845] Wed, 24 June 2009 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
http://asktom.oracle.com/tkyte/Misc/RolesAndProcedures.html
Re: Creating procedure dynamically-Insufficient privilages [message #409878 is a reply to message #409845] Wed, 24 June 2009 06:02 Go to previous message
anakin
Messages: 13
Registered: May 2009
Junior Member
Thanks very much.....
Previous Topic: Cursor and exception (Merged)
Next Topic: ANALYZE CONTINUES AFTER ORACLE ERROR ?
Goto Forum:
  


Current Time: Sun Dec 04 02:46:22 CST 2016

Total time taken to generate the page: 0.06804 seconds