SQL Developer for VS Code

Reason: queries against the data dictionary containing references to container-related columns (CON_ID, ORIGIN_CON_ID, etc.) can't run on DBs in release 11.2 or earlier: these columns were introduced in Oracle 12.1.

Please see https://oradiff.oracle.com

[1/25/2024, 12:49:33 PM] [dbtools-client  ] [TRACE] httpResult
{
  "url": "http://localhost:49570/20221610/databases/connections/sessions/BsENSsOZdHVsi-zIBHwwdw/actions/execute",
  "ok": true,
  "status": 200,
  "statusText": "OK",
  "body": {
    "env": {
      "defaultTimeZone": "Z"
    },
    "items": [
      {
        "statementId": 1,
        "statementType": "query",
        "statementPos": {
          "startLine": 0,
          "endLine": 6
        },
        "statementText": "WITH src AS (SELECT ROWNUM,LINE,TEXT,origin_con_id FROM SYS.ALL_SOURCE \n                        WHERE TYPE = :OBJECT_TYPE AND OWNER = :OBJECT_OWNER AND NAME = :OBJECT_NAME)\n                        SELECT text FROM src, (SELECT max(origin_con_id) max_orig FROM src)  \n                        WHERE origin_con_id = max_orig \n                        ORDER BY LINE",
        "response": [],
        "error": {
          "errorCode": "ORA-00904",
          "message": "\"ORIGIN_CON_ID\": invalid identifier",
          "cause": "The identifier or column name entered was invalid",
          "action": "Ensure the following",
          "line": 1,
          "column": 36
        },
        "errorCode": 904,
        "errorLine": 1,
        "errorColumn": 36,
        "errorMessage": "ORA-00904: \"ORIGIN_CON_ID\": invalid identifier",
        "errorDetails": "The identifier or column name entered was invalid"
      }
    ]
  }
}

Regards,