Oracle

UPDATE:2023-06-13

On this page

ODBC

  1. Driver install
  2. DSN Setting
    Windows : ODBC data source administrator

Method

  1. [System]Get TableName
    SELECT "TABLE_NAME","OWNER" FROM "ALL_TABLES"
    or SELECT "TABLE_NAME" FROM "ALL_TABLES"
  2. [System]Get FieldName and FieldType
    SELECT "COLUMN_ID","COLUMN_NAME","DATA_TYPE" FROM "ALL_TAB_COLUMNS" WHERE TABLE_NAME='<Table Name>'
    3. After obtaining the field names, check each column name and type. Columns of types that cannot be supported by SQL (e.g. "XMLTYPE") must be unchecked or the statement will fail.
    [Oracle][ODBC][Ora]ORA-01024: invalid datatype in OCI call