Hi Folks,
Does anyone have a sample oracle stored procedure that accepts variables and
returns multiple records? I.E. something to replace:

<cfquery...>
Select    column1, column2
FROM     mytable
WHERE    id = #variableid#

That would return something like (note multiple rows with multiple values
per row):

column1    column2
  A                B
  C                F
  D                U

My big ol' oracle pl/sql book is just confusing me more.

Thanks!
-Deanna



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to