I have some simple procedures in a DEV instance that run just fine (e.g.
enable_constraints, drop_table, insert_data). When I import them into the
PROD instance, they won't compile stating that
PROCEDURE ROSTERDBA.DROP_TABLE
On line: 7
PLS-00201: identifier 'SYS.DBMS_SQL' must be declared.
I am
Sorry for wasting the bandwidth
lc
-Original Message-
Sent: Thursday, July 05, 2001 4:00 PM
To: ORACLE-L@fatcity. com
Cc: Lisa R Clary
I have some simple procedures in a DEV instance that run just fine (e.g.
enable_constraints, drop_table, insert_data). When I import them into the
Title: RE: SQL ERROR--Nebulous definition
It's saying that execute permissions
on sys.dbms_sql must be granted
to ROSTERDBA
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
- Larry
