- Views 0
- Likes 0
Note to self: when receiving this error while executing DML using execute immediate, check for a semicolon (;) at the end of your statement. REMOVE!
Today is not a good day for writing code. After my battle with my unintended recursive procedure I got stuck again debugging for an hour and pulling my hair why o why the generated DML was working perfectly from SQL developer, but not from PL/SQL. After one hour I did what I should have done 50 minutes earlier. Googled and found the obvious answer I was missing… my DML contained a semicolon.
Let’s just say it’s one of those days!