MIME-Version: 1.0
References: <CABpiuuRGHX51vsuwrmS4saa+dj=Rq0gc4Y+bzUVo0-OFT=wmxA@mail.gmail.com>
 <CABpiuuQznpWiFU6EAYLXyYy8sz1cMjHiHVBARNDVmS5iMyp0dw@mail.gmail.com>
In-Reply-To: <CABpiuuQznpWiFU6EAYLXyYy8sz1cMjHiHVBARNDVmS5iMyp0dw@mail.gmail.com>
From: Jonathan Lewis <jlewisoracle@gmail.com>
Date: Sun, 17 Oct 2021 07:57:45 +0100
Message-ID: <CAGtsp8mUYKZk5bfPQ3adZ+giA+h83guf7dEJphv0bp6hKLvKag@mail.gmail.com>
Subject: Re: Don't sure whether it's a bug for raising an exception manually?
To: Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000bfbab205ce86f220"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jlewisoracle@gmail.com
--000000000000bfbab205ce86f220
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

In your exception clause you've handled the error (ctas_error) so the error
exists no more and the trigger code can complete successfully.

If you want an error to be passed on upwards (i.e. for the trigger to fail)
you have to raise another exception; typically you do this with the key
word "raise;" though sometimes people will (as you have done in the first
version of the code) "raise_application_error(......)" with some text that
you think is more informative that the internal Oracle error message.

Regards
Jonathan Lewis


On Sun, 17 Oct 2021 at 02:47, Quanwen Zhao <quanwenzhao@gmail.com> wrote:

>
>
> ---------- Forwarded message ---------
> =E5=8F=91=E4=BB=B6=E4=BA=BA=EF=BC=9A Quanwen Zhao <quanwenzhao@gmail.com>
> Date: 2021=E5=B9=B410=E6=9C=8816=E6=97=A5=E5=91=A8=E5=85=AD =E4=B8=8B=E5=
=8D=886:26
> Subject: Don't sure whether it's a bug for raising an exception manually?
> To: <oracle-l@freelists.org>
>
> *exception*
>> *  when ctas_err then*
>> *    dbms_output.put_line('Do not allow to CTAS big table ' || t_name ||
>> ' without keyword nologging.');*
>> end;
>> /
>>
>
>
>

--000000000000bfbab205ce86f220
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div>In your exception cla=
use you&#39;ve handled the error (ctas_error) so the error exists no more a=
nd the trigger code can complete successfully.</div><div><br></div><div>If =
you want an error to be passed on upwards (i.e. for the trigger to fail) yo=
u have to raise another exception; typically you do this with the key word =
&quot;raise;&quot; though sometimes people will (as you have done in the fi=
rst version of the code) &quot;raise_application_error(......)&quot; with s=
ome text that you think is more informative that the internal Oracle error =
message.</div><div><br></div><div>Regards</div><div>Jonathan Lewis</div><di=
v><br></div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Sun, 17 Oct 2021 at 02:47, Quanwen Zhao &lt;<=
a href=3D"mailto:quanwenzhao@gmail.com">quanwenzhao@gmail.com</a>&gt; wrote=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"lt=
r"><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>---------- Forwarded message ---------<br>=E5=8F=91=E4=BB=B6=E4=BA=BA=EF=
=BC=9A <b class=3D"gmail_sendername" dir=3D"auto">Quanwen Zhao</b> <span di=
r=3D"auto">&lt;<a href=3D"mailto:quanwenzhao@gmail.com" target=3D"_blank">q=
uanwenzhao@gmail.com</a>&gt;</span><br>Date: 2021=E5=B9=B410=E6=9C=8816=E6=
=97=A5=E5=91=A8=E5=85=AD =E4=B8=8B=E5=8D=886:26<br>Subject: Don&#39;t sure =
whether it&#39;s a bug for raising an exception manually?<br>To:  &lt;<a hr=
ef=3D"mailto:oracle-l@freelists.org" target=3D"_blank">oracle-l@freelists.o=
rg</a>&gt;<br></div><br><div dir=3D"ltr"><div style=3D"color:rgb(0,0,0);fon=
t-family:&quot;lucida Grande&quot;,Verdana,&quot;Microsoft YaHei&quot;;font=
-size:14px"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><b><font=
 style=3D"line-height:23.8px" color=3D"#ff0000">exception</font></b></div><=
div><b><font style=3D"line-height:23.8px" color=3D"#ff0000">=C2=A0 when cta=
s_err then</font></b></div><div><b><font style=3D"line-height:23.8px" color=
=3D"#ff0000">=C2=A0 =C2=A0 dbms_output.put_line(&#39;Do not allow to CTAS b=
ig table &#39; || t_name || &#39; without keyword nologging.&#39;);</font><=
/b></div><div>end;</div><div>/</div></blockquote><div><br></div><br></div><=
/div>
</div></div>
</blockquote></div></div>

--000000000000bfbab205ce86f220--
--
http://www.freelists.org/webpage/oracle-l