Re: SQL exception
From: Andy Hardy <Andrew.Hardy_at_BGTechnology.com>
Date: Thu, 5 Oct 2000 08:51:37 +0100
Message-ID: <8rhbs4$spe$1_at_sun-cc204.lboro.ac.uk>
Date: Thu, 5 Oct 2000 08:51:37 +0100
Message-ID: <8rhbs4$spe$1_at_sun-cc204.lboro.ac.uk>
Greg,
You cannot use the SQLERRM function in a SQL statement. Try obtaining the value separately e.g.
v_msg := SQLERRM;
INSERT INTO .....
( v_msg )
Andy
-- Opinions are mine and may not reflect those of BG Technology Ltd [Quoted] Greg <actiris_at_loxinfo.co.th> wrote in message news:39DC065D.9178DC1F_at_loxinfo.co.th...Received on Thu Oct 05 2000 - 09:51:37 CEST
> Have this part of a procedure
>
> exception
> when utl_smtp.transient_error or utl_smtp.permanent_error then
> utl_smtp.quit(c);
> insert into T_MAIL_LOG
> (SENDER,
> ERRORMESSAGE,
> DATE_TIME)
> values
> (Sender,
> sqlerrm,
> sysdate);
>
> 68/8 PLS-00231: function 'SQLERRM' may not be used in SQL
>
> how to bring the error message in to the table
>
> thanks greg
>