problem in Select in oracle tables
Posted: Mon Nov 24, 2008 7:32 am
hi,
i get the following error when i try access data from a table in the orale database using oracle oci stage:
Job_Exception_Report..Tbl_Exception_Tbl: ORA-00936: missing expression
Job_Exception_Report..Tbl_Exception_Tbl.DSLink1: DSP.Open GCI $DSP.Open error -100.
but when i run this query in sqlplus it runs fine.datastage and databse are in different servers. oracle client is installed where datastage in there.Also
oracle oci stage does not show the DSN created for the database when trying to see the table structure through load -> import -> ODBC table defenitions.
i get the following error when i try access data from a table in the orale database using oracle oci stage:
Job_Exception_Report..Tbl_Exception_Tbl: ORA-00936: missing expression
Job_Exception_Report..Tbl_Exception_Tbl.DSLink1: DSP.Open GCI $DSP.Open error -100.
but when i run this query in sqlplus it runs fine.datastage and databse are in different servers. oracle client is installed where datastage in there.Also
oracle oci stage does not show the DSN created for the database when trying to see the table structure through load -> import -> ODBC table defenitions.