CALLING UNCONNECTED STORED PROCEDURE

[DWResource]

I am trying to run an unconnected stored procedure which has an input parameter and an output parameter.

Stored Procedure has been defined in Oracle.

In Informatica, it is a TARGET POST-LOAD type.

It is an unconnected procedure.

In the properties tab, I have defined the call text as

P_proc1($$IN_PROCESS_DATE,$$OUT_RESULT)

IN_PROCESS_DATE and OUT_RESULT paramaters are I/P & O/P parameters of the SP.


PLEASE CORRECT ME IF I AM WRONG SO FAR.

I have Informatica CLIENT installed on my machine. So I am trying to pass these parms thru a PARM file.

I have define $$IN_PROCESS_DATE & $$OUT_RESULT as mapping parameters in the mapping.

In Workflow, when I define the parameter file as c:\in_parm1.txt


I GET an ERROR IN WF saying that file not found.

I am baffled on why the INFA is not able to see the PARM FILE if its right there.

PLEASE SUGGEST WHAT I AM DOING WRONG and What do I need to change to correct the problem.

Thanks In Advance.