The package DBMS_UTILITY.COMPILE_SCHEMA do not compile procudere but "ALTER PROCEDURE XXX COMPILE" w
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
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
0