SQL error

------=_Part_2003_18856615.1208616439809
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

HI everyone,


I=B4m trying to capture all the possible errors that a statement can have.
And, if there=B4s any error i will do a rollback; What i=B4m trying to do
i=
ts:
BEGIN
  insert into temp values(1, 2, 3);
  IF ANY_ERROR_OCCURED THEN
     ROLLBACK;
     RETURN FALSE;
  END IF;
END;

Did anyone knows how can i do that?

Thanks a lot!

------=_Part_2003_18856615.1208616439809
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

HI everyone,<br><br><br>I=B4m trying to capture all the possible errors
tha=
t a statement can have. And, if there=B4s any error i will do a rollback;
W=
hat i=B4m trying to do its:<br>BEGIN<br>&nbsp; insert into temp values(1,
2=
, 3);<br>
&nbsp; IF ANY_ERROR_OCCURED THEN<br>&nbsp;&nbsp;&nbsp;&nbsp;
ROLLBACK;<br>&=
nbsp; &nbsp;&nbsp; RETURN FALSE;<br>&nbsp; END IF;<br>END;<br><br>Did
anyon=
e knows how can i do that?<br><br>Thanks a lot! <br>

------=_Part_2003_18856615.1208616439809--