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"