Home » RDBMS Server » Server Administration » Is this Procedure is OK
Is this Procedure is OK [message #215863] Wed, 24 January 2007 02:06 Go to next message
Messages: 51
Registered: May 2005
Location: Bangalore

Please help me while i'm this proc i'm getting comapil error

Create or replace procedure mail1(text varchar2) is
--mailhost VARCHAR2(64) := 'visdy.ssds.slead.com';
sender VARCHAR2(64) := 'abc@abc.com';
recipient VARCHAR2(64) := 'xyz@xyz.com';
mail_conn utl_smtp.connection;

--mail_conn := utl_smtp.open_connection(mailhost, 25);
mail_conn := utl_smtp.open_connection(usage_rec.'',usage_rec.25);
utl_smtp.helo(mail_conn, usage_rec.'');
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.write_data(mail_conn, 'Subject: test'utl_tcp.CRLF);
utl_smtp.write_data(mail_conn, text|| chr(13));
Re: Is this Procedure is OK [message #215987 is a reply to message #215863] Wed, 24 January 2007 09:40 Go to previous message
Messages: 25537
Registered: January 2009
Location: SoCal
Senior Member
>Please help me while i'm this proc i'm getting comapil error
ERROR? What error? I don't see any error.
So how can we be expected to help you?
Previous Topic: what is Data base server
Next Topic: Archive in multiple destination
Goto Forum:

Current Time: Tue Jul 25 14:22:54 CDT 2017

Total time taken to generate the page: 0.20481 seconds