ORA:00904 Error

[scottr]

I am trying to insert data in to tabel which already has some data from .csv file.
in the oci stage after defining the columns ,if i click view data error is comming for the last column ORA-00904: "PID_TYPE": invalid identifier.

for test if change the columns order then also the error comming for the last column ORA-00904: "DATA_LABEL": invalid identifier

u guys have any idea what's wrong.

thanks for help.

[ketfos]

Hi,

Try changing column names in Designer and view the input data.


Ketfos

[kcbland]

You have to import the table definitions using DS Manager, then load those definitions into the OCI stage. In your transformer, map the incoming values from the file to the equivalent columns in the outbound link going to the OCI stage.

You MUST use the target tables definitions as loaded by DS. Never attempt to 'freehand' metadata, nor assume that metadata doesn't matter. IT DOES. DataStage relies on you using the appropriate metadata, that way it can adjust the data for the source/target.

[talk2shaanc]

Its Oracle error,
ORA-00904: string: invalid identifier
Cause: You tried to execute an SQL statement that included an invalid column name or the column name is missing.
Solution: Import proper metadata into your Oracle stage, directly from the DataBase, Instead of free hand typing. As every body has suggested.

[Sainath.Srinivasan]

Oracle points out invalid column names starting from the very last column in the list. Hence the change in error.

Maybe you can start with checking the table name as an incorrectly spelt table name may cause problem with all its columns.

Try to run the SQL in SQLplus or TOAD.

[talk2shaanc]

Hey,
Just trying to be more specific.If table name given in SQL query is incorrect and the table does not exist, the error will be ORA-00903: invalid table name.
If the incorrect Table name exist in the Data-Base then only you will get ORA-00904: invalid column name.

[Sainath.Srinivasan]

Yep talk2shaanc. You are correct. My words were to be read as the 'alias' used in the tablename not matching that of those prefixed in the column names.

I do not have Oracle here. So it is not possible to try the combination.

The first point of focus must be to make the SQL work (with hardcoded insert values) in any other client such as SQLPlus or TOAD.