July 24, 2008, 04:21 PMViral
StoreProc. Target error out - Communication error
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.
July 30, 2008, 07:26 PMZippo
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.