Home » SQL & PL/SQL » SQL & PL/SQL » How to catch the exception ORA-00923?
How to catch the exception ORA-00923? [message #289491] Sat, 22 December 2007 08:56 Go to next message
Messages: 19
Registered: November 2007
Junior Member

I wrote a procedures that make a parse on a sql statement.
If the statement is wrong I get the exception ora-00900.
So, how can I catch this exception?
Maybe there is already an delcared exception like wrong_sql_statement?

Re: How to catch the exception ORA-00923? [message #289493 is a reply to message #289491] Sat, 22 December 2007 09:17 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Chapter 10 Handling PL/SQL Errors

There is no such predefined exception you have to define your own.


[Updated on: Sat, 22 December 2007 09:18]

Report message to a moderator

Previous Topic: Help with this SQL join
Next Topic: Problem of ORA-00942
Goto Forum:

Current Time: Tue Oct 25 20:02:57 CDT 2016

Total time taken to generate the page: 0.09659 seconds