dcsimg
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: UTL_RAW

  1. #1

    Question 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

  2. #2

    UTL_RAW - what is the script to create package body?

    Can anyone help me please?

    Thanks,
    -Shyami

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    U don't need execute especial script for utl_raw package body.

  4. #4
    Then how come my package body was not created? When I try to use UTL_RAW.length I get an error message!

    Thanks,
    -Shyami

  5. #5
    Can anybody explain more on this please?

    Thanks,
    -Shyami

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    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?

  7. #7
    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

  8. #8
    I still have not resolved the problem, can someone help please?

    Thanks,
    -Shyami

  9. #9
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    You really don't have body - strange.

    Wrapped package body UTL_RAW is in $ORACLE_HOME\rdbms\admin\prvtrawb.plb

    Hope it helps,

    Tomaz


  10. #10
    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
  •  


Click Here to Expand Forum to Full Width