Re: How to determine if a Procedure fails?

From: Jan Peter Dompeling <jan-peter.dompeling_at_wxs.nl>
Date: Thu, 2 Sep 1999 20:23:47 +0200
Message-ID: <7qmfip$38dmf$1_at_reader3.wxs.nl>

Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Ken,

Take a look at this page:

http://www.compuware.com/products/iad/xpediter/detail/xsql_oracle.htm

and look at Integration and system testing section.

This can help you very much.

Good luck=20

Jan Peter Dompeling
Compuware Netherlands
+31 20 3118811

Ken Halsted <kenman_at_mail.snider.net> wrote in message = news:rst7b7l0j7138_at_corp.supernews.com...

> To: Faithful newsgroup
>=20
> I was wondering,
>=20
> Is there a way to determine if a STORED PROCEDURE fails when calling =

from a

> Forms 5 app?
>=20
> I thought about just changing it to a function and on an 'EXCEPTION
> handler', returning a 1 otherwise returning a zero.  But I thought =

there

> probably is a better way.
>=20
> I would appreciate some ideas on this.
>=20
> Thanks to all,
>=20
> Ken Halsted.
>=20
> --
> _________________
> Kenneth W. Halsted
> Mountaire Corporation
> ph: (501) 399-8812
> url: http://www.mountaire.com
> email: kenman_at_mail.snider.net
>=20
>=20
>=20

------=_NextPart_000_0025_01BEF581.0FE36660 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=3D2>Ken,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Take a look at this page:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2><A=20

href=3D"http://www.compuware.com/products/iad/xpediter/detail/xsql_oracle= .htm">http://www.compuware.com/products/iad/xpediter/detail/xsql_oracle.h= tm</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>and look at <STRONG>Integration and system testing=20
</STRONG>section.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>This can help you very much.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Good luck </FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Jan Peter Dompeling</FONT></DIV>
<DIV><FONT size=3D2>Compuware Netherlands</FONT></DIV>
<DIV><FONT size=3D2>+31 20 3118811</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Ken Halsted <<A=20
href=3D"mailto:kenman_at_mail.snider.net">kenman_at_mail.snider.net</A>> = wrote in=20
message <A=20
href=3D"news:rst7b7l0j7138_at_corp.supernews.com">news:rst7b7l0j7138_at_corp.su= pernews.com</A>...</FONT></DIV><FONT=20
size=3D2>> To: Faithful newsgroup<BR>> <BR>> I was = wondering,<BR>>=20
<BR>> Is there a way to determine if a STORED PROCEDURE fails when =
calling=20
from a<BR>> Forms 5 app?<BR>> <BR>> I thought about just = changing it to=20
a function and on an 'EXCEPTION<BR>> handler', returning a 1 = otherwise=20
returning a zero.  But I thought there<BR>> probably is a better =

way.<BR>> <BR>> I would appreciate some ideas on this.<BR>> =
<BR>>=20

Thanks to all,<BR>> <BR>> Ken Halsted.<BR>> <BR>> --<BR>> =

_________________<BR>&gt; Kenneth W. Halsted<BR>&gt; Mountaire=20

Corporation<BR>> ph: (501) 399-8812<BR>> url: <A=20 href=3D"http://www.mountaire.com">http://www.mountaire.com</A><BR>> = email: <A=20
href=3D"mailto:kenman_at_mail.snider.net">kenman_at_mail.snider.net</A><BR>>= <BR>>=20
<BR>> </FONT></BODY></HTML>

------=_NextPart_000_0025_01BEF581.0FE36660-- Received on Thu Sep 02 1999 - 20:23:47 CEST

This message: [ Message body ]
Next message: Jan Peter Dompeling: "Re: ORACLE TUNING SOFTWARE"
Previous message: TurkBear: "WebDB- Removing Sites...How"
In reply to: Ken Halsted: "How to determine if a Procedure fails?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message