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

Oracle-Connector fails parsing a DDL statement (external tables)

    XMLWordPrintable

Details

    Description

      While beeing in streaming mode the Oracle-Connector fails to handle the following DDL statement which is valid Oracle-SQL and excutes fine in the Oracle db:

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 

      create table imp_headline_ext (
car_id_no varchar2(255),
platfm varchar2(255),
my varchar2(255),
nl varchar2(255),
no_d varchar2(255),
nz_new_zealand varchar2(255),
pe_peru varchar2(255),
pl varchar2(255),
pt varchar2(255),
py_paraguay varchar2(255),
ro varchar2(255),
ru varchar2(255),
SA_SAUDI_ARABIA varchar2(255),
se varchar2(255),
sg_singapore varchar2(255),
si varchar2(255),
th varchar2(255),
tn_tunisia varchar2(255),
tr varchar2(255),
tw_taiwan varchar2(255),
ua varchar2(255),
us varchar2(255),
uy_uruguay varchar2(255),
vn_vietnam varchar2(255),
za varchar2(255),
total_quantity_vehicles varchar2(255),
headlinesort varchar2(255),
headlinekey varchar2(255),
tatus varchar2(255),
changes varchar2(255)
) ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER DEFAULT DIRECTORY "PISA_FZD" ACCESS PARAMETERS ( records delimited BY newline characterset 'WE8MSWIN1252' skip 1 fields terminated BY ";" lrtrim missing field VALUES are NULL) LOCATION ( 'HEADLINE.CSV')) REJECT LIMIT UNLIMITED;

      Attachments

        Issue Links

          causes

          Bug - A problem that impairs or prevents the functions of the product. DBZ-5108 Debezium connector failed with create table statement

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          incorporates

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4794 Get ddl parse error when running maven with tests

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-4706 Oracle parsing error for ALTER TABLE EXT_SIX LOCATION

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

              anmohant Anisha Mohanty
              codebude Raffael Herrmann (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: