I have currently using APEX 5.
I created a survey page and wanted to record people's opinion. It is a very simply form with 3 questions, a name and a date.
Everything seems running but I was not able to make the DML(Automatic Row Processing) work?
I have created a submit button and set it with "SQL insert action". no condition on anything
Then, I created the DML process "insert data into table" with table name, column name, and colum id. No extra condition at all.
However, when I "submit" my data, I got this error:
ORA-06550: line 1, column 52: PL/SQL: ORA-00928: missing SELECT keyword ORA-06550: line 1, column 13: PL/SQL: SQL Statement ignored
I read something like the Automatic Row Fetch must be ran before have this DML. However, I really do not need to see any old/other data.
I tried to delete this process and my app ran perfectly. I knew because I have a clear all fields after this "submit"
Anyone has any suggestions?
Thank you very much and have a blessed day