Tuxedo Application Rehosting Workbench Problem Parsing SQL FETCH Syntax (Doc ID 2101699.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle Tuxedo Application Rehosting Workbench - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problems Parsing the following SQL FETCH syntax examples:

*ERROR File MYFILE1.cpy, line 25:
    FETCH INSENSITIVE MYCURSOR1
                 ^error here
PHOENIX-IDENTIFIERS::MYCURSOR1 is a symbol, which is not a legal token
at this point in the input. The legal tokens at this point are:
 "using"  "into"  "for"

  

*ERROR File MYFILE2.cbl, line 854:     FETCH BEFORE MYCUSOR2                 
error here PHOENIX-IDENTIFIERS::MYCURSOR2 is a symbol, which is not a legal token at this point in the input.
The legal tokens at this point are:
"from"
error is encountered with syntax :
EXEC SQL     FETCH BEFORE MYCURSOR2     END-EXEC.

 

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms