Add this sql report Error at Line 3: ora-97: Missing Right Parenthesis to the shell.

Personally, ORA-97 is an all-out error report when oracle has nothing to report and cannot be implemented.

this ora error is a joke in itself, so if you want to report this error, you should first copy the statement into the common execution connection window to see if it can be executed. If the statement can be executed in the common connection, it means that there is no error in the statement itself, and then go to find the connection. I remember reading the connection method of OLEDB somewhere and I don't know the casewhen. I am looking for the connection method. If it still doesn't work, there is basically no way.

Of course, if the copied part can't be executed in the window, it means that the statement itself is wrong, so you should look for it yourself.

In addition, when writing sql in the shell, I remember that there seems to be an escape problem of single quotation marks. I haven't written it for a long time, but I don't remember it clearly. You can also try it.