> Hi all,
>
> I need help in inserting a value from sequence. My
> code goes like this (from Java). I do face a syntax
> level problem.
>
> statement.execute("insert into T_name (id) values (" +
> nextval('s_name') + ")");
>
> Thanks in advance for the help.
nextval is a sql function, not java so it must be sent inside
the string to execute :
statement.execute("insert into T_name (id) values
(nextval('s_name'))");
Alain
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com