When I do something like this I usually create a view in oracle then create a "View Form" in remedy that uses the view I created in Oracle. But have you tried returning a CURSOR ??? Honestly I doubt it would work but in theory it might. Let me know if you are able to get it to work cause it would be valuable knowledge for me as well.
Thanks, Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of L G Robinson Sent: Tuesday, October 20, 2009 2:41 PM To: [email protected] Subject: Re: Stored procedures in Sybase vs Oracle Sorry... I forgot my sig. Larry Robinson [email protected] 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:[email protected] ARSlist: "Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
