INFA 6.2
ORACLE 9.2
Mapping is required to call a function fnName(in_Voucher,out_ResultCode,out_ResultMessage). The function is embedded in a package.
I tried using the Stored Proc transform to call this function (when I use the SP Import, it does see it) but I am getting an error similar to below when running the mapping:
ORA-06550: line 1, column 7:
PLS-00221: 'fnName' is not a procedure or is undefined
ORA-06550: line 1, column 7:
Am wondering if anyone has executed a function via an INFA transform.
Am also wondering if perhaps a stored proc needs to be created as a "wrapper" around the function call - i.e. I can't call the function directly (at least using the SP transform).
Thanks
ORACLE 9.2
Mapping is required to call a function fnName(in_Voucher,out_ResultCode,out_ResultMessage). The function is embedded in a package.
I tried using the Stored Proc transform to call this function (when I use the SP Import, it does see it) but I am getting an error similar to below when running the mapping:
ORA-06550: line 1, column 7:
PLS-00221: 'fnName' is not a procedure or is undefined
ORA-06550: line 1, column 7:
Am wondering if anyone has executed a function via an INFA transform.
Am also wondering if perhaps a stored proc needs to be created as a "wrapper" around the function call - i.e. I can't call the function directly (at least using the SP transform).
Thanks