var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: me again
hello you lot,
i am attempting to send an email from my oracle 9 database.
I searched google and found http://otn.oracle.com/sample_code/te...tp_Sample.html at Oracle. Seemed like a good bet.
Every time i try to run the script it results in this error
which according to this ( http://www.csis.gvsu.edu/GeneralInfo...90842/ch14.htm ) page means
SP2-0423: Illegal GET command
This makes no sense to me. I am sure this should work, it is afterall from oracle.
SP2-0423 Illegal GET command
Cause: An invalid option was used in the GET command.
Action: Check the syntax of the command you used for the correct options.
Can anyone else help me with an example?!
Re: me again
This should work for simple emails:
CREATE OR REPLACE
PROCEDURE send_mail (p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
l_mailhost VARCHAR2(255) := 'yourdomain.com';
l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
e.g. exec send_mail ('firstname.lastname@example.org','email@example.com','Hello');
Many thanks andrew!!!
I am now looking at doing HTML emails...hopefully it won't bee tooo hard!