Database Administration (MOSC)

MOSC Banner

The package DBMS_UTILITY.COMPILE_SCHEMA do not compile procudere but "ALTER PROCEDURE XXX COMPILE" w

edited Mar 16, 2011 5:18PM in Database Administration (MOSC) 5 commentsAnswered
 Hi,       After upgrade from 10.2.0.3 to 10.2.0.5,  dbms_utility.compile_schema do not work to compile a procedure.Simultated test case is

1. Create a table called dummytbl
SQL> create table DUMMYTBL
  2  (
  3    DUMMY1 VARCHAR2(4)
  4  );

Table created.
2. Create a procedure called dummy
SQL> create Procedure Dummy
  2  AS
  3
  4  tdummy      dummytbl.dummy1%Type;
  5
  6  BEGIN
  7
  8  Select Dummy1
  9  into tdummy from dummytbl;
 10
 11
 12  END;
 13  /

Procedure created.

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE         CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
------------------------------ ---------- -------------- ------------------- --------- --------- ------------------- ------- - - -
TESTING
DUMMY
                                  1424826                PROCEDURE           15-MAR-11 15-MAR-11 2011-03-15:14:35:58 VALID   N N N

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center