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:[email protected]] On Behalf Of Frank Caruso
Sent: Tuesday, October 17, 2006 12:40 PM
To: [email protected]
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___
