raghava

• Sep 21st, 2006

 

Hi,

   U can call stored procedure from workflow manager through DSN name.

Just u specify DSN of stored procedure.

ok

Dorababu Kottapalli

• Jan 2nd, 2007

 

Hi,

What are the steps to call a stored procedure in workflow manager.

please give me detailed spet by step solution. The procedure is in oracle 10g on unix os.

Thanks & Regards

Dorababu K

lewiscl2

 Profile Answers by lewiscl2 

• May 23rd, 2008

 

how do you call an oracle stored procedure in Informatica?

sarita.harsh

 Profile Answers by sarita.harsh 

• Mar 5th, 2009

 

Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connections give the appropriate connection where you created the procedure. In properties in pre-SQL write CALL procedure_name();

rajvinformatica

 Profile Answers by rajvinformatica 

• Mar 28th, 2010

 

I have written as Stored Procedure to get all the Tables from a two Server 

Server1 and Server2 (parameterized Values) and load them in to two different tables 

internally through the S.P

This Stored Procedure will have 2 input Parameters (Server1 and Server 2) and doest not return any Parameters.

So how to give the Server1 and Server2 names Dynamically(parameter's)and how to call this Stored Procedure in Informatica.

I really appreciate your help with Step by step Process.

Thanks

Raj