23
Views
8
Comments
Solved
ORA-00923 From keyword not found
Question

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.



Rank: #36639
Solution

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.

 

Rank: #144

Hi Sheetal,

You can write database exception handling as per below screenshot.


Vijay M-

Rank: #393

Hi Sheetal,

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

Sheetal wrote:

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.



 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

 

Rank: #36639

Hi Hans,

Actually i write an advanced query in which i am getting this error.

Rank: #144

Hi Sheetal,

Check once whether the brackets are properly set in query.