Forum Stats

  • 3,760,389 Users
  • 2,251,695 Discussions
  • 7,871,091 Comments

Discussions

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

3761118
3761118 Member Posts: 2

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,