Are you getting "ORA-00936: missing expression" error while trying to update existing data using tabular form?
Are you using "Multi Row Update" or "Tabular Form" processes (ApplyMRU or Apply MRD), then most probably the issue is with a space or new line character you have entered in "Runtime Where Clause" section of "ApplyMRU" process
However to know the exact reason behind the error, run page in debug mode and try saving data. Then see debug output. If the issue is with space or new line character which you have entered, then you will see entry similar to below
as you can see above (highlighted with yellow color), APEX finds there is some value entered for "Runtime Where Clause" and it will append this where clause to update query. Since it's not a valid SQL Update statement, we will get "ORA-00936: missing expression" error.
Fix: It's obvious. Go to page designer and remove any spaces or new line characters entered in "Runtime Where Clause" section and save changes. This should fix the issue.
This issue or bug was also there in APEX 4.2 version, however, in ver. 4.2 when you try to edit "ApplyMRU" process (as developer using application builder), then APEX detects and ignores any spaces and new line characters in "Runtime Where Clause" section & TRIMs them our during page load itself. So in this case, you can just edit "ApplyMRU" process and you can click on "Apply Changes" button. This will fix the issue.
Are you using "Multi Row Update" or "Tabular Form" processes (ApplyMRU or Apply MRD), then most probably the issue is with a space or new line character you have entered in "Runtime Where Clause" section of "ApplyMRU" process
However to know the exact reason behind the error, run page in debug mode and try saving data. Then see debug output. If the issue is with space or new line character which you have entered, then you will see entry similar to below
as you can see above (highlighted with yellow color), APEX finds there is some value entered for "Runtime Where Clause" and it will append this where clause to update query. Since it's not a valid SQL Update statement, we will get "ORA-00936: missing expression" error.
Fix: It's obvious. Go to page designer and remove any spaces or new line characters entered in "Runtime Where Clause" section and save changes. This should fix the issue.
This issue or bug was also there in APEX 4.2 version, however, in ver. 4.2 when you try to edit "ApplyMRU" process (as developer using application builder), then APEX detects and ignores any spaces and new line characters in "Runtime Where Clause" section & TRIMs them our during page load itself. So in this case, you can just edit "ApplyMRU" process and you can click on "Apply Changes" button. This will fix the issue.
Comments