DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: unable to create package utl_mail in 10g

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    Question unable to create package utl_mail in 10g

    Environment: 10g (Windows server)

    I am unable to create package utl_mail, Please help.
    See below:


    1. In oracle 10.2.0.2.0 WE8MSWIN1252 AMERICAN_AMERICA database

    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql

    Package created

    Synonym created

    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb

    Warning: Package body created with compilation errors
    Errors for PACKAGE BODY SYSTEM.UTL_MAIL:

    LINE/COL ERROR
    -------- -----------------------------------------------
    320/10 PL/SQL: ORA-00942: table or view does not exist
    319/5 PL/SQL: SQL Statement ignored
    326/12 PL/SQL: ORA-00942: table or view does not exist
    325/7 PL/SQL: SQL Statement ignored

    ==================================================

    2. In oracle 10.2.0.1.0 AL32UTF8 AMERICAN_AMERICA database

    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql

    Package created

    Synonym created

    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb

    Warning: Package body created with compilation errors
    Errors for PACKAGE BODY SYSTEM.UTL_MAIL:

    LINE/COL ERROR
    -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    85/2 PLS-00103: Encountered the symbol "TITRXOTC8"
    85/27 PLS-00103: Encountered the symbol "=" when expecting one of the following:


    -D

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to create them as sys not system

  3. #3
    Join Date
    Jul 2003
    Posts
    136
    Quote Originally Posted by davey23uk
    you need to create them as sys not system
    Doing it with sys worked fine on
    1. In oracle 10.2.0.2.0 WE8MSWIN1252 AMERICAN_AMERICA database. It created the pkg and body.

    But I still get the original error on
    2. In oracle 10.2.0.1.0 AL32UTF8 AMERICAN_AMERICA database


    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql

    Package created

    Synonym created

    SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb

    Warning: Package body created with compilation errors
    Errors for PACKAGE BODY SYS.UTL_MAIL:

    LINE/COL ERROR
    -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    85/2 PLS-00103: Encountered the symbol "TITRXOTC8"
    85/27 PLS-00103: Encountered the symbol "=" when expecting one of the following:

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