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