Hi Larry, check the Oracle function DUAL there are references in past arslist tips using this to build menus and/or select data and present it as a list to user.
> -----Original Message----- > From: n...@ncsu.edu > Sent: Tue, 20 Oct 2009 14:40:59 -0400 > To: arslist@arslist.org > Subject: Re: Stored procedures in Sybase vs Oracle > > Sorry... I forgot my sig. > > Larry Robinson n...@ncsu.edu > Remedy Developer/Admin > Office of Information Technology > NC State University 919-515-5432 Voice > Raleigh, NC 27695-7109 919-513-1893 FAX > > > On Oct 20, 2009, at 12:16 PM, L G Robinson wrote: > >> Hi Folks, >> >> I am in the early stages of a migration from Sybase to Oracle and I >> am struggling with stored procedures. >> >> One of the nice things about Sybase is the ease with which one could >> return data to the ARS system using stored procedures. I am finding >> this much more difficult in the Oracle environment. When using a >> SetFields operation in an Active Link, one can invoke a Sybase >> stored procedure that includes a SELECT statement and the results of >> the select are presented back to ARS as $1$, $2$, etc. If multiple >> rows are returned, you can display them and let the user choose the >> record they want. Simple. >> >> In Oracle, I have discovered that stored procedures do not return >> anything. However, Oracle Functions return one "thing. The "thing" >> can be a singe value or something more complex such as a row or a >> table or some other user-defined Oracle object. The trouble I am >> having is understanding how to define the Oracle "thing" that I want >> to return so that it behaves the same way that it does with Sybase. >> Is it a RECORD, an OBJECT or an array or a table? Or something else? >> I know my way around Sybase pretty well, but this is my first >> exposure to Oracle. >> >> If anyone has any experience in this area and could nudge me in the >> right direction, I would greatly appreciate it. I am willing to put >> in the time to learn whatever I need to learn... I just need some >> direction. References to helpful documentation or a working example >> would be most helpful. >> >> ARS 5.1.2 >> Sybase 12.5.2 >> Oracle 10.2.0.4.0 >> >> Thanks. >> Larry >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the >> Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers > Are" ____________________________________________________________ Receive Notifications of Incoming Messages Easily monitor multiple email accounts & access them with a click. Visit http://www.inbox.com/notifier and check it out! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
