If you want to insert a PL/SQL block using the <cfquery> tag you might see that your trigger, package, etc. is being saved in the Oracle database but it throws an error while executing, but Inserting the same PL/SQL statement within Oracle works just fine.
Now before you go and rewrite your whole SQL statement within the <cfquery> many times there is luckily an easy answer to this challenge; With ColdFusion you can not issue a SQL statement within the <cfquery> tag which uses a “;”.
So what to do? Read on to see how to overcome this challenge.
If you enjoyed this post, make sure you subscribe to my RSS feed!
