Skip to Content
0
Jun 29, 2012 at 06:47 AM

Calling a Database Stored Function

130 Views

Hi, is there a way to call an oracle stored function in an (remote-)database directly from a "to Database" Pass or via JavaScript? The Signature of the Stored Oracle Function is like this:
-----------------------------------------
create or replace
FUNCTION MyFunction ( pDatum IN DATE)
RETURN NUMBER ...
-----------------------------------------
An additional question is how to call oracle stored procedures with "IN OUT" Parameters from a Pass or a JavaScript.
We are using IdM 7.2 Stack 4. The Oracle Database is Version 10
Thanks in advance, Matthias