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 Wall (creator of Perl)
> -----Original Message-----
> From: Lisa Clary [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 05, 2001 5:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL ERROR--Nebulous definition
>
>
> 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 not sure what this is telling me--any ideas? I am
> exporting as one user
> then importing as another--but all activity does occur within its own
> schema.
>
> thanks,
>
> lc
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lisa Clary
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
