calling function for every input record into oci stage

bobbysridhar · Post by **bobbysridhar** » Thu Apr 26, 2012 11:24 am

Hi,
I am trying to call a function from oracle database to OCI target stage update statement. But it is giving error.
Can somebody send me the syntax for it.

update abc set cri=1,doNotRenewInd=getTransactionIND('abc.policynumbr','dnrFlag');,cancelNoticeInd = getTransactionIND('abc.policynumbr','cancelNotice'); where policysummary.id in (select ps.id from policySummary ps where ps.revisionNo =0

qt_ky · Post by **qt_ky** » Thu Apr 26, 2012 5:49 pm

Try adding the closing paren. ) and removing ; semicolons.

chulett · Post by **chulett** » Thu Apr 26, 2012 6:14 pm

Why not share with us the error that you are seeing?