I am facing problem in using oracle functions in the DBread step.
I have to use the encryption function of the oracle DB to encrypt the PIN for IVR system for HR information. The employee enters the PIN and this has to be compared to the encrypted PIN saved in the DB. The following SQL statement is used for this purpose.
select * from IVR_EMPLOYEE_DETAILS
where EMP_NO = $strEmpNum AND TPIN = Encriptdata($strPin)
in the above statement $strEmpNum and $strPin are variable from the script storing the employee number and Pin.
I am getting error "variable strPin) is not defined" when I am adding the above statement in the field selection of the DB read step.
If I remove the function and just put
select * from IVR_EMPLOYEE_DETAILS
where EMP_NO = $strEmpNum AND TPIN = $strPin
there is no error.
Please advise how to call the oracle functions in the SQL statement.
