Hi Bill
I get the results from an Oracle procedure using a set fields, sql action
(from an AL but I don't see why this wouldn't work from a filter).
The sql is
select prime_decode '$SecurityCode$' from dual
where prime_decode is an Oracle stored procedure which requires a value
supplied by the $SecurityCode' field. It returns one result value.
HTH
Cheers
Peter
-----Original Message-----
From: Myers, Bill [mailto:bill.myers@PGNMAIL.COM]
Sent: 19 December 2001 21:54
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Values From an Oracle Process/Function
**
Is it possible to return values from an Oracle process/function into a
Remedy record? We have a process that is used to validate accounting code
data and we need to run this process in a filter on submit and return an
error to the user if the validation fails.
ARS 4.05.02
Oracle 8.0.6 on HPUX
NT 4.0
Thanks!
Bill Myers
Progress Energy Service Company
(p)919-546-2503
(f)919-546-2435
bill.myers@pgnmail.com
________________
_____________
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org
Please visit us at http://www.sonybiz.net
*************************************************************************
The information contained in this message or any of its
attachments may be privileged and confidential and intended
for the exclusive use of the addressee. If you are not the
addressee any disclosure, reproduction, distribution or other
dissemination or use of this communication is strictly prohibited
*************************************************************************
_____________________________
Previous Topic
Index