?: Help in Package Creation..

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Thu, 21 Dec 2000 18:04:02 +0900
Message-Id: <10717.125090@fatcity.com>

I think you have to recompile the package=20 withthis command.

alter package packagename compile;

For this you hace alter any procedure privs required.

alter package packagename compile body.

Hpoe this help.

-----OE=B3'=CCf=81fbfZ=81[fW-----
=8D=B7=8Fo=90l: Arul kumar [mailto:rakumar_at_mahindrabt.com] '-=90M"=FAZz: Thursday, December 21, 2000 PM 04:22 ^=B6=90=E6: Multiple recipients of list ORACLE-L OE=8F-=BC: Help in Package Creation..

Hi DBAs,

I was creating a package. After executing the script, ( got message "Package Created & Package Body Created") i am not able to execute it. When i queried USER_OBJECTS it has INVALID status for both SPEC & BODY of that
package.

Sequence of execution : First Spec & then Body . Right?

What went wrong? Pl. help me.

TIA
Arul.

--=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20

Author: Arul kumar
  INET: rakumar_at_mahindrabt.com

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 Dec 21 2000 - 03:04:02 CST