using a sequence in sqlj?

Question

I'm new to sqlj and try to insert data with an id generated by a sequence. This is my current code:

String pattern = ...;
#sql {INSERT INTO my_table (id, pattern) VALUES (my_seq.nextVal(), :(pattern))};

but I keep getting and ORA-02287 Error. Do I need to do it differently?

Note: PL/SQL is based on Ada, not C, and as such you don't need to put parentheses after a function name to invoke it; as a matter of fact, if you DO put parentheses in where they're not wanted you'll get an error (as you've discovered). Best of luck. — Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні, Commented Dec 31, 2015 at 2:37
the confusing thing was that I got an error that didn't lead me into thinking that there was a syntactical error. — EasterBunnyBugSmasher
– EasterBunnyBugSmasher, Commented Jan 4, 2016 at 13:06
Oracle is well known for producing error messages that are, to put it nicely, not obviously helpful. Best of luck. — Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні, Commented Jan 4, 2016 at 16:17

collapsar · Accepted Answer · 2015-12-30 14:51:02Z

2

Omit the parentheses after nextval:

#sql {INSERT INTO my_table (id, pattern) VALUES (my_seq.nextval, :(pattern))};

answered Dec 30, 2015 at 14:51

collapsar

17.4k5 gold badges40 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aleksej · Accepted Answer · 2015-12-30 14:08:59Z

2

Not expert on sqlJ, but in the SQL part you should use my_seq.nextVal, with no ()

answered Dec 30, 2015 at 14:08

Aleksej

23.1k6 gold badges38 silver badges41 bronze badges