SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table is not creating while using stored procedure

559976Nov 1 2009 — edited Nov 2 2009

Hi to all,

I am using Oracle 9.2.0.3 and having following problem while creating a table inside stored procedure.

following is the procedure:
is
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE hashim.A(NAMEv VARCHAR2(100))';
END TEST;

following is the error which we are getting:

SQL> exec report.test;
BEGIN report.test; END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "REPORT.TEST", line 3
ORA-06512: at line 1

I have checked all the privileges and found everything fine.

Can anyone please help me why I am getting the above error?

Thanks in Advance
Hashim

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2009

Added on Nov 1 2009

10 comments

12,199 views