| Sending Email Database through PL/SQL [message #369712] |
Thu, 24 August 2000 09:10 |
Sivakumar SG
Messages: 14
Registered: August 2000
|
Junior Member |
|
|
Please help me in this particular situation.
My requirement is to sent email from Database through Pl/SQL block. OS is Solaris 5.6 and Oracle 8.1.6
I am using utl_tcp package options to send the mail. Program is getting compiled. But when i try to execute the program, it is going to exception handling and when i display the error message it says "ORA 29540 class oracle/net/plsql/TCPconnection not available.
How will i add classes to already installed oracle?
We have a SMTP mail server. Is TCP utility function is enough or should I use SMTP utilities. If so what should i do to execute the code. Already the TCP as well as SMTP pacakges are available in my database( I am able to view the packages and the functions inside).
If any one can help me to solve this problem, it will be great to me. My doubts are
Is TCP utility enough to sent mail.
If so what should I do to over come the ORA 29540 error ( Jave class not available error).
If not and if i have to use SMTP packages, can any one sent me a piece of code ( which is already functioning).
Please get me back as early as possible as the requirement is urgent .
Thanks in Advance
Siva
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
