Functions can return multiple values - you probably
already knew that :) Another option that is
useful in certain circumstances is to use a db View and Selecting from it within
workflow. The db View can call multiple functions which retrieves and
formats the returned columns.
HTH
Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Tuesday, October 17, 2006 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle and Stored Procedures
Thank you
On 10/17/06, Heider,
Stephen <[EMAIL PROTECTED] >
wrote:
Frank,
As far as I know calling SPs from workflow will never return values.
Could you use a function instead?
Stephen
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso
Sent: Tuesday, October 17, 2006 12:40 PM
To: arslist@ARSLIST.ORG
Subject: Oracle and Stored Procedures
ARS 6.03
Oracle 9i
AIX 5.5
I do not think this is possible, at least it wasn't in ARS versions 3,4
and 5.
Want to call a stored procedure from Remedy against an Oracle 9i
database:
DECLARE
handle NUMBER;
rec_out NUMBER;
BEGIN
elig.OPEN('B',handle,rec_out);
END;
Want to then retrieve the values of handle and rec_out ad stored them in
a form field.
Thank you
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___