01-21-06, 11:57
|
|
Registered User
|
|
Join Date: Jan 2006
Posts: 11
|
|
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:
Quote:
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:
Quote:
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.
__________________
Gaetano N.
|
|
dBforums
>
Sendmail installation under Oracle 10g
Linear Mode
