Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4224

DDL statement couldn't be parsed

    XMLWordPrintable

Details

    Description

      Creating oracle queue table failed with DDL statement couldn't be parsed:

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE "U3"."TEST_QUEUE_TABLE"(q_name            VARCHAR2(128),msgid              RAW(16),corrid             VARCHAR2(128),priority           NUMBER,state              NUMBER,delay              TIMESTAMP,expiration         NUMBER,time_manager_info  TIMESTAMP,local_order_no     NUMBER,chain_no           NUMBER,cscn               NUMBER,dscn               NUMBER,enq_time           TIMESTAMP,enq_uid             VARCHAR2(128), enq_tid            VARCHAR2(30),deq_time           TIMESTAMP,deq_uid             VARCHAR2(128), deq_tid            VARCHAR2(30),retry_count        NUMBER,exception_qschema  VARCHAR2(128),exception_queue    VARCHAR2(128),step_no            NUMBER,recipient_key      NUMBER,dequeue_msgid      RAW(16),sender_name    VARCHAR2(128),sender_address VARCHAR2(1024),sender_protocol NUMBER,USER_DATA "SYS"."AQ$_JMS_TEXT_MESSAGE",user_prop      SYS.ANYDATA, PRIMARY KEY(msgid) ) USAGE QUEUE ;'
      mismatched input 'USAGE' expecting \{'AS', ';'}
      

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            ahmad.abed911 Ahmad Abed
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: