This content has been marked as final. Show 4 replies
I have executed your query
select * from dba_objects where status='INVALID' and object_name='TPC_ORDER_REPORTS_PKG';
Result : Blank record
Means not any row fetch. I have checked executing following query.
select * from dba_objects where status='VALID' and object_name='TPC_ORDER_REPORTS_PKG';
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY
APPS TPC_ORDER_REPORTS_PKG 571808 PACKAGE 1/13/2011 8:53:20 PM 1/7/2013 6:10:40 AM 2013-01-07:06:10:40 VALID N N N
APPS TPC_ORDER_REPORTS_PKG 571811 PACKAGE BODY 1/13/2011 9:18:15 PM 1/15/2013 8:02:03 PM 2013-01-15:20:02:03 VALID N N N
Hence I sure package is valid .......
Edited by: 973411 on Jan 21, 2013 4:05 AM
Edited by: 973411 on Jan 21, 2013 4:06 AM