DSXchange

still iam facing same problem. I did same thing what u mention please solve my problem.

Hi, Iam using oracle connectoe stage in my job,when try to read the data iam geting the below error. And even iam try load the data also iam geting same error . pls can anybody help me to solve the problem . The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-0140...

thanks for reply me and can u tell error abut" nls"

Hi, I have a problem with Oracle connector stage in job when it is reading the data from table. It is given below error please help me to resolve the error. The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-01406: fetched column value was truncated. (CC_OraConne...

Hai craig can u reply me plz

this is the where clause in my filter


(CONTRACT_SUB_TYPE='VarianceIndexSwap' or CONTRACT_SUB_TYPE='VarianceBasketSwap' or CONTRACT_SUB_TYPE='VarianceShareSwap') and EQTY_SUBMISSION_ID=TMP_ACTIVE_SUB_ID and (TRANS_TYPE='Termination' or TRANS_TYPE='Novation' or TRANS_TYPE='Exercise-Callable')

i have filter stage in job here iam getting this below error
Filter_1: Parse error: Expected comparison operator ('>', '<', ...) after literal, got: <eof>.

can anybody help to solve this problem pls

Thaks,
ravi