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
