Hi guys,
I have a database link to Sybase ASE database using dg4odbc.
But when trying to create a procedure to insert into table in Sybase, I have an error, ORA-00904: "alarmTS": invalid identifier.
Table UAlarm created in Sybase.
| Column ID | Column Name | Data Type | Length |
| 1 | entity_id | smallint | 2 |
| 2 | obj_id | varchar | 20 |
| 3 | alarmTS | datetime | 8 |
| 4 | alarmClass | tinyint | 1 |
| 5 | alarmNo | int | 4 |
| 6 | alarmText | varchar | 255 |
SQL> desc "dbo"."UAlarm"@sybasedb;
Name Null? Type
----------------------------------------- -------- ----------------------------
entity_id NOT NULL NUMBER(5)
obj_id NOT NULL VARCHAR2(60)
alarmClass NOT NULL NUMBER(3)
alarmNo NOT NULL NUMBER(10)
alarmText NOT NULL VARCHAR2(765)
I can't find "alarmTS" column, and for your information, that column can't be null.
My environments:
- Oracle Database 11g R2 (11.2.0.4)
- Oracle Database Gateway for ODBC 11g R2 (11.2.0.1)
- SAP Sybase ASE 15.7
Please help.