Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to use SyntaxError.checkSyntax class in sqlcli to check syntax

3761118Aug 15 2018

Hi,

I am trying to automate sql syntax check using sqlcli supplied jar file dbtools-common.jar in the lib dir for sqlcl-18.2.0

Sometimes it gives me this error and I am not able to figure out what this means

Expected: name_wo_function_call,identifier,name,sim_stmt,sql

Expected: name_wo_function_call,identifier,name,labeled_nonb

Have anyone who used SQL Developer or SQLcl for chcking syntax errors faced this issue,

Any insight would be good for me,

Thanks,

Comments

Post Details

Added on Aug 15 2018
0 comments
370 views