I'm an old MSSQL guy, and I'm stumped by the way Oracle does SELECT-type stored procedures (not action, but returning rows). Anyone know a link to a good website with a tutorial they can share? Seems like I've been through all of Googles.
Why can't Oracle make this easy?
check the proc examples. They create a package, in the package they create the procs. For every resultset you have to return a REF CURSOR. LLBLGen Pro then takes care of loading the data into datatables/sets.