Wrapping BEGIN and END around the statements should be enough. http://docstore.mik.ua/orelly/oracle/prog2/ch15_03.htm
http://www.orafaq.com/wiki/Anonymous_block etc mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/31 Victor Moore <victor.mo...@gmail.com>: > > Hi James, > > Thank you for the quick response > I'm a newbie when it comes to PL/SQL. Can you please show me how would > i do it considering the previous example, or at least a link where > would explain it. > > Thanks > Victor > > On Sat, Oct 31, 2009 at 10:56 AM, James Holmes <james.hol...@gmail.com> wrote: >> >> If you want to run multiple statements in a single cfquery tag in >> oracle you need to write PL/SQL. An anonymous block would do the >> trick. >> >> mxAjax / CFAjax docs and other useful articles: >> http://www.bifrost.com.au/blog/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4