how to disable EXCEPTIONS in PL/SQL ?
From: Sy Jerry <SYJERRY_at_duq3.cc.duq.edu>
Date: 11 Oct 1994 01:13:44 GMT
Message-ID: <37cos8$bp7_at_godot.cc.duq.edu>
Date: 11 Oct 1994 01:13:44 GMT
Message-ID: <37cos8$bp7_at_godot.cc.duq.edu>
I am writing several PL/SQL procedures and I can't seem to find a way to disable EXCEPTIONS. I find it annoying when I do a singleton select and if there are no records found, an exception occurs and aborts the procedure!! I'd like to use SQLCODE function to check for error status so I maintain control of the program.
any ideas ?
please email replies if possible
thanks in advance
jerry Received on Tue Oct 11 1994 - 02:13:44 CET