DSXchange

Learning on the job, working hard making a lot of mistakes. Tanks to DSX for the help.

I solved the problem. Unbelievable how i found the solution...just choosing a NLS set in the OCI. I changed it from Project Default (NONE) to ISO8859-1 and i read data :shock: Why does it has to be like this on this OCI and not the same on the other ? In truth i should check database NLS configurati...

********************* Oracle DB server version Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production CORE 9.2.0.8.0 Production TNS for HPUX: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production ********************* Oracle client versi...

Test done. Nothing changes :( Query changed to SELECT /*+ PARALLEL(a,4) */ a.COD_PORTFOLIO, a.COD_IMSI, a.FLG_PROSPECT, a.FLG_USIM_SCIOLTA FROM #DDSOWNERE#.TF_NDM_PORTFOLIO a where a.FLG_PROSPECT='Y' and a.FLG_USIM_SCIOLTA='Y' Challenging problem, isn't it ? I solved many other worst problems within...

I'm MaxRevan. I'm using my friend's account cause i'm having problems with mine :cry: The job has several parameters. Those used within the OCI are correctly used and set. Custom query of the OCI is SELECT /*+ PARALLEL(a,4) */ COD_PORTFOLIO, COD_IMSI, FLG_PROSPECT, FLG_USIM_SCIOLTA FROM #DDSOWNERE#....