-
UTL_RAW - what is the script to create the package body?
Hi pals,
I tried to create the package UTL_RAW using utlraw.sql, the package body was not created though. What script do I run to create the package body? Is there any site which lists out all the scripts in the rdbms/admin folder and the use for it?
Thanks in advance,
-Shyami
-
UTL_RAW - what is the script to create package body?
Can anyone help me please?
Thanks,
-Shyami
-
U don't need execute especial script for utl_raw package body.
-
Then how come my package body was not created? When I try to use UTL_RAW.length I get an error message!
Thanks,
-Shyami
-
Can anybody explain more on this please?
Thanks,
-Shyami
-
Try:
select object_name, object_type, status from dba_objects where object_name = 'UTL_RAW';
Is package_body there and VALID.
What error message do you get?
-
When I check the dba_objects/user_objects table the result that I get is...
OBJECT_NAME
----------------------------------------------------
OBJECT_TYPE STATUS
--------------- -------
UTL_RAW
PACKAGE VALID
I do not see any entry for package body.
The error message I get is
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "ADMIN.UTL_RAW" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 11
Thanks,
-Shyami
-
I still have not resolved the problem, can someone help please?
Thanks,
-Shyami
-
You really don't have body - strange.
Wrapped package body UTL_RAW is in $ORACLE_HOME\rdbms\admin\prvtrawb.plb
Hope it helps,
Tomaz
-
TomazZ,
thanks for the guidance, tried creating the package body using .plb but all I got was
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY UTL_RAW:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [56104]
Synonym dropped.
Synonym created.
grant execute on sys.utl_raw to public
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
----------------------------------------------------------------
It will be great if someone can send me a copy of the actual .sql script to create the package body by e-mail to shyamala.sathiaseelan@eds.com please...
Thanks,
-Shyami
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
|