Skip navigation
Contact Us
15494 Views 5 Replies Latest reply: Apr 9, 2012 12:23 PM by Troy Thomsen RSS
karthik padmanabhan Novice 66 posts since
Dec 16, 2010
Currently Being Moderated

Sep 29, 2011 4:37 AM

How to call an oracle SP in informatica?

Hi Frienz,

     I need to run an Oracle SP in informatica, Which is in different server.


     I am loading data from one oracle server to another oracle server. (Its like one to one mapping) From one table to another,

     After that i need to execute an SP from that same Oracle server. (That i can given in the POST SQL in the target table in Informatica)


     I know how to run the SQL SP, is by giving EXEC spname,

     but in Oracle 10 g how to execute the SP?


     kindly let me know..

More Like This

  • Retrieving data ...

Bookmarked By (0)