multiple PL/SQL statements in cfquery

I’ve run into an issue where I need to run 2 PL/SQL statements on Oracle in a single cfquery tag. In my SQL developer, I can run 2 at a time using a semi-colon as a delimiter but cfquery errors out on me saying the semi-colon is an invalid character. Here’s the query that I’m trying to run:

Re: multiple PL/SQL statements in cfquery

On Wednesday 15 Aug 2007, [EMAIL PROTECTED] wrote: ALTER SESSION SET NLS_DATE_FORMAT = '­MM­DD HH24:MI:SS'; SELECT SYSDATE as theDate, startDate, TO_CHAR(startdate, '­MM­DD HH24:MI:SS') as maskedDate Data formating is not the job of the database. Return a proper date, and format