On 12/8/05, James Holmes <[EMAIL PROTECTED]> wrote: > Not to mention that since there is no declared cursor you are relying > on an implicit cursor but; > > 1) this looks like it will return more than one row, which is a no-no > with an implicit cursor and > 2) there is no INTO clause to store the result, so the procedure won't > run anyway. > > Start with a procedure known to work properly and go from there. If > you want this example to be a procedure, declare a cursor and use > cfstoredproc. >
Just a side note on your cursor comment, as you seem to suggest that not using an explicit cursor is somehow bad. I would actually advise *against* explicit cursors in almost all cases. Here's supporting evidence from Oracle guru Tom Kyte himself, who demonstrates conclusively with thorough test cases that implicit cursors actually perform *better* than explicit cursors: http://www.oracle.com/technology/oramag/oracle/03-jan/o13asktom.html and http://asktom.oracle.com/~tkyte/ivse.html The funny part about the Oracle development community that I've seen online and work(ed) with is that there is a tremendous amount of "old school" thought processes that go into making critical decisions, when those thought processes are clearly dated. In no way is that an attack on you (please don't take it that way). It's really a shot at the six-figure salary DBAs I've come across who are stuck in 1990! Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226574 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
