-
compilation error
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 ?
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
So PAVB what we can do to solve this issue, can you specify the solution
-
How about troubleshooting it?
You can start by login into the database as 'INTRANET_USER' and running queries below...
Code:
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'
/
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
Originally Posted by PAVB
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]
Last edited by gopu_g; 07-03-2008 at 05:12 AM.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|