In the ADODB Object Generator that I’ve posted previously, I have added a semi-column in the end of SQL queries nothing really special until now ! But I was surprised to get an ORA-00936 error missing expression — while processing OCI function OPARSE. Copy paste the same sql on any other client it works fine …
I remember I have seen this error before, but I have forgot how I solve it. So today I said that I have to blog about it so I won’t forget it anymore. If you get this error simply remove the Fatal Semi Column in the end of the SQL query and try again.