Disonnecting from database
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)
capture the email id from some table;
con = utl_smtp.connection (host,25);
I execut this procedure in the following way
wher send_mail is the .sql file of the above code.
I get the following error and i am disconnected from the data base.
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
What might be the reason? This is happening for this procedure only. I was able to compile many before this.
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Syntax error seems likely unless he has a stored type called varcahr2...
Originally Posted by PAVB
this space intentionally left blank
varcahr is typographical error. that was an accident
Click Here to Expand Forum to Full Width