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
novalex
Messages: 19
Registered: November 2007
Junior Member
Hi!

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?

Thanks
bye
Alex
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: 64102
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.

Regards
Michel

[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: Sat Dec 03 00:52:10 CST 2016

Total time taken to generate the page: 0.05198 seconds