I have some pl/sql I want to run in my cfquery.

I'd like to get the output from the cfquery

The cfquery is calling a function.

<cfquery name="MyQuery" ......>
declare
myupdates integer;
myinserts integer;
begin
if update_mytbl('#var1#') = 0 then
if insert_mytbl('#var1#') = 1 then
myinserts := myinserts + 1;
end if;
else
myupdates := myupdates + 1;
end if;
dbms_output.put_line(myupdates);
dbms_output.put_line(myinserts);
end;
</cfquery>

<cfdump var="MyQuery"> produces an error

Mike