Our developer wrote a program that is dealing with a large amount of data from one DB and pushing it to another DB (after converting it from MSSQL. The statement she is using is:
SELECT MYFIELD_SEQ.NEXTVAL NEW_ID FROM DUAL;
We've noticed that the program that is issuing this statement slows down after some time. Looking in the DB logs we see:
2019-12-04T10:34:18.937766-06:00
MO(4):WARNING: too many parse errors, count=1026276 SQL hash=0x23acadbc
MO(4):PARSE ERROR: ospid=9860, error=904 for statement:
2019-12-04T10:34:18.937766-06:00
MO(4):SELECT "NEW_ID", ROWID InternalRowid FROM DUAL
MO(4):Additional information: hd=0000012B2BB4CF00 phd=0000012B869366F8 flg=0x20 cisid=110 sid=110 ciuid=110 uid=110
It looks like Oracle is adding the " " to NEW_ID. The command works without the quotes
The client is 11.2.0.4 (because we are still using oo4o) and the database we are converting into is 12.2