DataDirect ODBC error running Oracle Stored Procedure
Posted: Tue Jun 08, 2004 12:26 pm
We have an ODBC job which executes an Oracle Stored Procedure that is failing in the ODBC driver with the following error.
DataStage Job 860 Phantom 19861
6066:
[DataDirect][ODBC 20101 driver]6060
DataStage Phantom Finished
There was a QEWSD= entry in the .odbc.ini file which I removed. When they reran the job the QEWSD= entry had reappeared and the job failed. Jobs that do not run stored procedures run successfully. Developer has verified the Oracle Id can run the stored procedure in SQLPlus.
Any ideas?
Leroy Gharis
JPMorganChase
DataStage Job 860 Phantom 19861
6066:
[DataDirect][ODBC 20101 driver]6060
DataStage Phantom Finished
There was a QEWSD= entry in the .odbc.ini file which I removed. When they reran the job the QEWSD= entry had reappeared and the job failed. Jobs that do not run stored procedures run successfully. Developer has verified the Oracle Id can run the stored procedure in SQLPlus.
Any ideas?
Leroy Gharis
JPMorganChase