Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    11

    Red face Unanswered: Sendmail installation under Oracle 10g

    Hi to all,

    I have installed Oracle 10g and an application yhat run with 10g.
    I need to install a sendmail interface, that the application developer has provided to me.
    This sendmail has 4 files.
    This is the readme:
    1) From MS-PROMPT run
    loadjava -user
    sys/xxxxx@xxxx -resolve -synonym activation.jar
    loadjava -user
    sys/xxxxx@xxxx -resolve -synonym mail.jar
    2) From SQLPLUS as SYS
    call dbms_java.grant_permission('PUBLIC','SYS:java.io.F ilePermission','<<ALL FILES>>','read,write');
    call dbms_java.grant_permission('PUBLIC','SYS:java.util .PropertyPermission','*','read,write');
    call dbms_java.grant_permission('PUBLIC','SYS:java.net. SocketPermission','*','connect,resolve');

    3) From SQLPLUS as SYS
    @sendmailjpkg.sql ;

    4) CREATE PUBLIC SYNONYM "SENDMAILJPKG" FOR "SYS"."SENDMAILJPKG" ;
    GRANT EXECUTE ON "SYS".SENDMAILJPKG TO "PUBLIC" ;
    All is OK for 1) and 2)

    But, when I run "@sendmailjpkg.sql;", the error message is displayed:
    CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "SENDMAIL" AS *
    ERROR at row 1:
    ORA-29536: bad format origin : Encountered "/" at line 134, column 1.
    Was expecting one of:
    <EOF>
    "#sql" ...
    "abstract" ...
    "final" ...
    "public" ...
    "class" ...
    "interface" ...
    ";" ...
    "\\u001a" ...

    Warning: package created with compilation errors.
    Warning: package body created with compilation errors.


    I hope that everyone can help me. The used files are attached to this thread.

    Thank You and Best Regards.
    Attached Files Attached Files
    Gaetano N.

  2. #2
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    I think SQL Plus might be having some problems to recognize the java comments lines.
    What SQL Plus version do you have?
    Try removing the comments inside the java source (all "// ") an run it again.

    Saludos...

  3. #3
    Join Date
    Jan 2015
    Posts
    1

    Installation Guide

    Hi Gaetano N.

    Actually i am using Oracle R12 ON 10g Database

    I am trying to implement Sendmail feature. Have couple of questions

    1) will there be any impact to existing functionality if we install this package
    2) Can this package be used to send mail outside the server (like supplier/customer personal email id)
    3) Can you please share the Oracle documentation or Metalink notes for this installation

    Thanks
    Lava

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •