I did not try it in a CFC and did not try it all within one line so guessing that is why it failed for me. I actually have no real need for it, just always been something I have wondered how to get working.
On 6/9/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: > > > i see the bug outside a CFC as well: > > <cfquery name="anonplsqltest" datasource="trademak"> > declare > nextid number; > begin > select s.nextval into nextid from dual; > end; > </cfquery> > > throws > [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 8: > PLS-00103: Encountered the symbol "" when expecting one of the > following: begin function package pragma procedure subtype type use > form current cursor > > whereas > > <cfquery name="anonplsqltest" datasource="trademak"> > declare nextid number; begin select s.nextval into nextid from dual; > end; > </cfquery> > > doesn't throw an error. > > but it doesn't return anything either: > > <cfdump var="#anonplsqltest#"> > > throws > > Variable ANONPLSQLTEST is undefined. > > so you could use anonymous pl/sql to wrap several statements together in > a single database call, but i don't see how you could use it to get > things out from the db. > > > /t > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
