problem in Select in oracle tables

[vintipa]

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.

[chulett]

OCI != ODBC, use the Plug-in OCI metadata method to import. If you are using custom / user-defined SQL in the stage, post it.