RE: SQL ERROR--Nebulous definition

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 05 Jul 2001 13:38:24 -0700
Message-ID: <F001.003421F5.20010705133529@fatcity.com>

It's saying that execute permissions
on sys.dbms_sql must be granted
 to ROSTERDBA

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com 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:lisa_at_cog.ufl.edu]
> 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: lisa_at_cog.ufl.edu

>
> 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: ListGuru_at_fatcity.com (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).
>
Received on Thu Jul 05 2001 - 15:38:24 CDT