Privilege of dbms_sql?

In SQL environment, I can excute the following line

CREATE OR REPLACE VIEW viewName AS SELECT * FROM tableName <conditions>

But, if I put the line in "dbms_sql.parse" and run the procedure, I get

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "OLDFAST.DEMO", line 50
ORA-06512: at line 2

Why? How to fix it?

Thanks. Received on Wed Dec 01 1999 - 20:06:39 CST