X Tutup
The Wayback Machine - https://web.archive.org/web/20201011182837/https://github.com/JSQLParser/JSqlParser/issues/1059
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create or replace statement parse error #1059

Closed
kaplan441 opened this issue Oct 2, 2020 · 0 comments
Closed

Create or replace statement parse error #1059

kaplan441 opened this issue Oct 2, 2020 · 0 comments

Comments

@kaplan441
Copy link

@kaplan441 kaplan441 commented Oct 2, 2020

I have a create or replace function(procedure,etc) script. When i parse the script, it throws exception.
When I remove "or" statement, it parses successfully.

SQL like this;

CREATE OR REPLACE Function FindCourse
   ( name_in IN varchar2 )
   RETURN number
IS
   cnumber number;

   cursor c1 is
   SELECT course_number
     FROM courses_tbl
     WHERE course_name = name_in;

BEGIN

   open c1;
   fetch c1 into cnumber;

   if c1%notfound then
      cnumber := 9999;
   end if;

   close c1;

RETURN cnumber;

EXCEPTION
WHEN OTHERS THEN
   raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
END;

Exception;

net.sf.jsqlparser.JSQLParserException: null
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:151) ~[jsqlparser-3.2.jar:?]
        ...

Was expecting one of:

    ";"
    "CALL"
    "COMMENT"
    "COMMIT"
    "DECLARE"
    "DELETE"
    "DESCRIBE"
    "DROP"
    "EXEC"
    "EXECUTE"
    "EXPLAIN"
    "GRANT"
    "INSERT"
    "MERGE"
    "SET"
    "SHOW"
    "TRUNCATE"
    "UPDATE"
    "UPSERT"
    "USE"
    "VALUES"
    "WITH"

	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:25031) ~[jsqlparser-3.2.jar:?]
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:24875) ~[jsqlparser-3.2.jar:?]
	at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:244) ~[jsqlparser-3.2.jar:?]
	at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:498) ~[jsqlparser-3.2.jar:?]
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:149) ~[jsqlparser-3.2.jar:?]
	... 106 more

My java version 11
JSqlParser version 3.2

@wumpz wumpz closed this in 3e84a37 Oct 4, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.
X Tutup