plsql-parser icon indicating copy to clipboard operation
plsql-parser copied to clipboard

Throwing error for parsing FOR loop statement

Open mohitchawda opened this issue 11 years ago • 0 comments

Hi, I amusing this parser to parse Oracle SQl based files. Following FOR statements are getting parsed succesfully, 1. for i in 1 ..l_line_tbl.xyz() LOOP l_line_xyz(i).random_ship_date := l_random_date; l_line_xyz(i).random_set_id := x_random_set_id; END LOOP; 2. for i in 1..5 LOOP l_line_xyz(i).random_ship_date := l_random_date; l_line_xyz(i).random_set_id := x_random_set_id; END LOOP; 3. for i in 1 ..5 LOOP l_line_xyz(i).random_ship_date := l_random_date; l_line_xyz(i).random_set_id := x_random_set_id; END LOOP;

But, this is failing, 1. for i in 1..l_line_tbl.xyz() LOOP l_line_xyz(i).random_ship_date := l_random_date; l_line_xyz(i).random_set_id := x_random_set_id; END LOOP;

If upper bound is a function call and there is no space between lower bound and double period, then is not parsing.

Has anyone encountered this issue?

mohitchawda avatar Dec 22 '14 12:12 mohitchawda