Procobol Produces Invalid Sql Statements With COMMON_PARSER=YES And Have With Statement (Doc ID 2872145.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Symptoms :

============================

In COBOL ,
Cursor contains WITH Statement and it is used directly between EXEC SQL and END-EXEC .
next step to cursor declaration is cursor open and fetch
and immediate step to fetch is "select count(*) into :h9-count from dual"

During compilation , keyword common_parser=yes used to compile WITH statements without errors.

program once pre-compiled and generated .cbl file and in .cbl file
wrote query as "WITH count ( * ) into :b1 from DUAL" instead of "select count(*) into :b1 from dual"

Same SQL was working in version 12.1.0.2 but not working in 12.2.0.1 and 19.10
when WITH statement used dynamically , .cbl file generated properly .

Working Scenario :
===================

Changes

 None.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.