Hi All,
I'm getting the below error
ORA-00923 From keyword not found.
Can i write database error handling exception for this type of error.
need help.
Vijay Malviya wrote:
Hi Sheetal,
You can write database exception handling as per below screenshot.
Vijay M-
Thanks vijay,
There is any document for exception handling.
Sheetal wrote:
Have a look on Handle Exceptions links.
Hope this helps
based on the error.. I would expect that your SQL query isn't correct. And that you first might to validate the SQL query.
Regards,
Hans
Hello Sheetal,
handling exception is about showing a user friendly user message upon exception but it cannot be solution to your issue.
I believe you have used SQL widget and written some query which is throwing this error. Kindly verify your query, most probably you query syntax is not correct or you have used something which OS's Sql server engine is not able to understand so it is not able to read 'from' keyword hence throwing that error. First Test your query in Sql widget and check for syntax.
hope it helps you.
Thanks,
Sanjay
Hi Hans,
Actually i write an advanced query in which i am getting this error.
You can post your query here for our better understanding.
Check once whether the brackets are properly set in query.