Hi,
Iam using oracle 9i release 2. I want to send mail thru oracle 9i database.
for that i got a procedure from net. Also they asked to follow three steps. the steps are
1. Execute the script as sys "$ORACLE_HOME\javavm\insta
ll\initjvm
.sql"
2. Execute the loadjava classfile as
$ORACLE_HOME\plsql\jlib>lo
adjava -f -v -r -u sys/**** plsql.jar
3. Execute the script as sys "$ORACLE_HOME\rdbms\admin\
initplsj.s
ql"
I sucessfully executed the first step, but for the second step iam not able to locate the plsql.jar file in the specified path.
So Please tell me if there is any other method to perform this task
Regards
Raja
the procedure i executed is given below
**************************
**********
*******
Declare
SendorAddress Varchar2(30) := 'raja@sw.com';
ReceiverAddress varchar2(30) := 'DBA@sw.com';
EmailServer varchar2(30) := 'mail.sw.com';
Port number := 25;
conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2( 4000 );
mesg_body varchar2(4000);
BEGIN
conn:= utl_smtp.open_connection( EmailServer, Port );
utl_smtp.helo( conn, EmailServer );
utl_smtp.mail( conn, SendorAddress);
utl_smtp.rcpt( conn, ReceiverAddress );
mesg:=
'Date: '||TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' )|| crlf ||
'From:'||SendorAddress|| crlf ||
'Subject: Mail Through ORACLE Database' || crlf ||
'To: '||ReceiverAddress || crlf ||
'' || crlf ||
' This is Mail from Oracle Database By Using UTL_SMTP Package'||crlf||'It is very easy to configure Tell me if you face any problems' ;
utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );
END;
**************************
**********
********
Start Free Trial