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"
