Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem calling ORACLE (PL/SQL) function from mapping

Status
Not open for further replies.

bsellick

Programmer
Jul 26, 2001
24
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top