Print Thread
Intercept PL/SQL error code
#46654 03/28/13 01:00 PM
Joined: Mar 2013
Posts: 8
N
nrsgzz Offline OP
Member
OP Offline
Member
N
Joined: Mar 2013
Posts: 8
Hi all.
I would like to present the user with a warning if he forgets to fill out the whole form. In this case oracle would return:

[quote]ORA-06550: line 2, column 104:
PL/SQL: ORA-00936: missing expression
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
[/quote]

However ORA-06550 is a generic error, what I'm interested in is the PL/SQL ORA-00936.
How can I read it?

Thanks!

Re: Intercept PL/SQL error code
nrsgzz #46663 03/29/13 10:37 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
You will need to parse the error text (EOracelError.Message) in case of an ORA-06550 exception.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 15 (0.010s) Memory: 2.4964 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 07:32:20 UTC
Valid HTML 5 and Valid CSS