ORA-00904 Invalid Identifier

[sgelinas]

We are using a character set of UTF-8 on the server (10g).

In our apps we are inserting data (TOracleDataset) and receive an error:
insert into pir_organization t (pir_orga_id, name) values ('42', 'test orga')

ORA-00904:"TC"."TYPE#":invalid identifier

I set the property BytesPerCharacter to bcAutoDetect.

Even in PL/SQL Developper (6.0.5) we got the same error.

We are using DOA version 4.0.6 for delphi 7.

Any helps?

 

[Marco Kalter]

Can you send me the table definition?

 

[sgelinas]

ML_PORTAL@TESTUTF8
index

Table PIR_ORGANIZATION

--------------------------------------------------------------------------------
Columns
Name Type Optional Default Comments
ORGA_ID VARCHAR2(32)
PIR_ORGA_ID VARCHAR2(32) Y
NAME VARCHAR2(80)
CTRL_CHECK NUMBER(4) 1

--------------------------------------------------------------------------------
Primary Key
Name Columns
PK_PIR_ORGANIZATION ORGA_ID

--------------------------------------------------------------------------------
Foreign Keys
Name Columns Referencing Table Columns
FK_PIR_ORGA_ORGA_ORGA_PIR_ORGA PIR_ORGA_ID PIR_ORGANIZATION ORGA_ID

--------------------------------------------------------------------------------
Indexes
Name Columns Type
ORGA_ORGA_FK_FK PIR_ORGA_ID Normal
PK_PIR_ORGANIZATION ORGA_ID Unique

--------------------------------------------------------------------------------

It seems that the oracle catalog was corrupted.
we did a catproc and now it seems to work.