Disonnecting from database

[vamsioracle]

Hi all

I have created a procedure to send mail, using utl_smtp package. the code goes like this

create or replace procedure send_mail(parma1 In date,param2 in date)
is
email varchar2(100);
subject varchar2(100);
conn utl_smtp.connection;
begin

capture the email id from some table;
con = utl_smtp.connection (host,25);
utl_smtp.helo(conn, host)
utl_smtp.mail(conn,email)

utl_smtp.open_data(conn)
.
.
.
.
end;

I execut this procedure in the following way
SQL:> @c:\scripts\send_mail.sql;

wher send_mail is the .sql file of the above code.

I get the following error and i am disconnected from the data base.


SQL:> @c:\scripts\send_mail.sql;

Unknown command at the beginning email varcahr2 .... rest of the line ignored
Unknown command at the beginning subject varcahr2 .... rest of the line ignored

ORA-12203 -TNS: unable to conect to destination

Warning: You are no longer connected to Oracle
Not Connected
SQL>



What might be the reason? This is happening for this procedure only. I was able to compile many before this.

vamsi

[PAVB]

Most likely you have a syntax error; hard to say 'cause you are not showing your code and you are not actually copy/pasting the error stack. It doesn't say varcahr2, does it?

[gandolf989]

Most likely you have a syntax error; hard to say 'cause you are not showing your code and you are not actually copy/pasting the error stack. It doesn't say varcahr2, does it?

Syntax error seems likely unless he has a stored type called varcahr2...

[vamsioracle]

thanks buddies

varcahr is typographical error. that was an accident