Focal Point
StoreProc. Target error out - Communication error

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5251048292

July 24, 2008, 04:21 PM
Viral
StoreProc. Target error out - Communication error
Hello,

I am call the oracle store procedure which will have some business rules and update the table.
When try to test my synonym (needs to pass the value as a input to the store procedure requires the input), it works fine and actually I am getting desire output, like inserted the data in my oracle table.
But same thing Trying to use the store procedure as a target. It errors out saying communication error.
Anybody had this issue and how did you resolved.

Thanks in advance.

DM- 7.6.2. WF - 7.6.2.
OS - WIN2003K.


WF 7.6.2/ OS WIN2003.
DM 7.6.2
July 30, 2008, 07:26 PM
Zippo
Just to be clear, you are using a synonym for a stored procedure as the target in a data migrator flow?

If so take a look at this link, it states using a stored procedure as a target is not supported but there is a possible workaround.

http://techsupport.informationbuilders.com/sps/41842556.html

Perhaps if you open a case with IBI they can submit the problem as a new feature.