odbc connection

[pkomalla]

hi all,

I am using a odbc stage to access oracle database in one of my job.

It was working fine in production. Recently we added new jobs to the same project and tried to run the whole project for testing and found an error in accessing odbc stage.

I checked the ODBC connections it is working fine.

this job or stage has nothing to do with new jobs added.

When I tried to view data from ODBC stage below error shows up

jobname..oci_stagename.lk_linkname: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was: SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (t.col3=?)
UNION
SELECT
t.col1,
t.col2,
NVL(t.col3, t.col1)
FROM
tablename T
WHERE
T.THREAD_NUM=1
AND (T.col1=?)
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value


anyone had same issue or have an answer to it

thanks

[DSguru2B]

Did'nt you get a similar problem resolved here?