compilation error

[gopu_g]

when i try to compile the package i am gettting this error...

BEGIN GDC_TS_DATA_TRANS_PKG.GDC_PRC_TRANS_QD_LOAD; END;

*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of INTRANET_USER.GDC_TS_DATA_TRANS_PKG
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

is the problem is with db or in the code of the package ?

[PAVB]

problem appears to be with the code but the affected package is part of your database then you can safely say problem is with either one or both

[gopu_g]

So PAVB what we can do to solve this issue, can you specify the solution

[PAVB]

How about troubleshooting it?
You can start by login into the database as 'INTRANET_USER' and running queries below...

select  user
from    dual
/
select  * 
from    dba_role_privs 
where   grantee = (select user from dual)
/
select  owner,
        object_name,
        object_type,
        status
from    dba_objects
where   owner = 'INTRANET_USER'
and     object_name = 'GDC_TS_DATA_TRANS_PKG'
/

[gopu_g]

the result of the last query is like this....The package body is invalid...


OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- ---------------------- ------------------ -------
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE VALID
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE BODY INVALID

[gopu_g]

How about troubleshooting it?
You can start by login into the database as 'INTRANET_USER' and running queries below...
[CODE]select user
from dual
/
USER
------------------------------
INTRANET_USER

[CODE]select *
from dba_role_privs
where grantee = (select user from dual)
/


GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
INTRANET_USER CONNECT NO YES
INTRANET_USER READALL NO YES
INTRANET_USER RESOURCE NO YES

[/QUOTE]
[CODE]select owner,
object_name,
object_type,
status
from dba_objects
where owner = 'INTRANET_USER'
and object_name = 'GDC_TS_DATA_TRANS_PKG'


OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- ---------------------- ------------------ -------
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE VALID
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE BODY INVALID

[/QUOTE]

[gopu_g]

i compiled the package again.. now the status is valid..



OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- ---------------------- ------------------ -------
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE VALID
INTRANET_USER GDC_TS_DATA_TRANS_PKG PACKAGE BODY VALID