DSXchange

What the job does is selects data thru OBDC stage then to a Transformer stage then to a hash file. then after a while the job aborts. Kindly help us to resolve this.... Here is the log generated by our job: JOLoadHSHDfUnbBillInfoFinalFeb..TR_Df_Unb_Bill_Info.LK_ORA_Df_Unb_Bill_Info: DSD.BCIGetNext c...

ok tnx, ill try to talk to our administrators.

chulett,

yes im sure. i've tried it. btw the OCI plugin that comes with our DataStage version is 1.5. and it can connect only to Oracle 7. thanks for the info.....

chulett,

the Datastage version we're using does'nt support connection to Oracle 9i thru OCI stage. We're using version 5.2. I think this a limitation of the agreement between our company and Ascential.

I can connect to the database thru sqlplus and toad. this is another error log after the one i've already posted: JOLoadDfLoadProfile2a..ORA_Lp_raw_max_tabs.LK_ORA_Lp_raw_max_tabs: DSD.BCIClose SQLSTATE=60, DBMS.CODE=-3113 [DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][Oracle]11604 Can...