scripts/multiple queries in one CF Query block in Oracle

[acsdirect]

Greetings:

I am primarily an MS SQL programmer and I am wondering how to run multiple
query statements inside a single cfquery block. For example, on MS SQL I can do
multiple delete statements, or an update and select within one cfquery block,
but I get an error whenever I try to do this on ORACLE. Is there a way to
accomplish this on ORACLE?

thanks!

[Dan Bracuk]

No there isn't

[paross1]

Your best bet would be to use multiple CFQUERY tags within CFTRANSACTION tags
if you want them all to be handled in a "block" or "session". Or, put all of
your SQL statements in a PL/SQL stored procedure.

Phil

[acsdirect]

ok, thanks a lot.