Help: dynamic sql

From: <badstreetboy_at_my-dejanews.com>
Date: 1998/10/20
Message-ID: <70godi$rn5$1@nnrp1.dejanews.com>#1/1

I was trying to use dynamic sql package 'dbms_sql' to execute DDL statements 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

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 CDT