Help: dynamic sql

[Quoted] [Quoted] I was trying to use dynamic sql package 'dbms_sql' to execute DDL statements [Quoted] within PL/SQL. After I run the 2 startup packages(dbmssql.sql, prvtsql.plb) as user 'SYS', I am only able to run the dbms_sql package as 'SYS'. When I connect to another user to use dbms_sql package, I got an error.

SQL> execute exec('create table t1(f1 integer)');

ERROR at line 1:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "ANOTHER_USER.DBMS_SQL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "ANOTHER_USER.EXEC", line 5
ORA-06512: at line 1

[Quoted] Please help. Thanks!!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 00:00:00 CEST