Blog Archives

Execute immediate results in ora-00911 invalid character

Note to self: when receiving this error while executing DML using execute immediate, check for a semicolon (;) at the end of your statement. REMOVE! Share PostTwitterFacebookGoogle +1Email

Posted in Oracle, PEBKAC, Pl/Sql Tagged with: , ,

Unintended recursiveness

Today I learned another PL/SQL feature… the hard way. I was busy writing¬† some new code to import and process meta data. When testing the procedures performing a simple import¬† my procedure call kept running indefinitely and the OS load

Posted in Oracle Tagged with: ,