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 - Слава Україні, Dec 31 '15 at 02:37
the confusing thing was that I got an error that didn't lead me into thinking that there was a syntactical error. — EasterBunnyBugSmasher, Jan 04 '16 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 - Слава Україні, Jan 04 '16 at 16:17

score 2 · Answer 1 · answered Dec 30 '15 at 14:08

2

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

answered Dec 30 '15 at 14:08

Aleksej

score 2 · Accepted Answer · answered Dec 30 '15 at 14:51

2

Omit the parentheses after nextval:

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

answered Dec 30 '15 at 14:51

collapsar

2 Answers2