A simple way would be for Procedure B has an OUT parameter which
you can then return a success or failure status.

Regards Kevin B.

PRIVILEGED, PRIVATE AND CONFIDENTIAL
=======================================================
The information contained in this electronic message e-mail, and
any files transmitted with it, is intended for the named recipient(s)
only. If you are not the intended recipient, you must not copy,
distribute or take any action in reliance on it, please delete it
immediately and notify me of the error by reply e-mail. I do not
represent, warrant or guarantee that the integrity of this
communication has been maintained nor that the communication
is free of errors, virus or interference.
=======================================================
Kevin Biasi
Software Engineer
Dimension Data
Telephone - 61 3 9626-0379
E-ddress - kevin.[Email address protected]




"Mohanty Deepak K \(GE Consumer & Industrial consultant\) "
<oracledba-ezmlmshield-x6391041.[Email address protected]
29/10/2004 03:41 PM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Exception handller problem




HI
i have two procedure
one is Procedure A
2nd is Procedure B

Procedure A calls Procedure B .
Procedure B has exception handler inside it ,my problem is that i want to
know if any error occour in procedure B how can i know from procedure A.

Thanks


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page