Alejandro Pancani writes:

.... The problem is that when I execute the Zsql method 'sql_2' it seems to execute the sql_select_next_val method two times because at the next time that I execute 'sql_2' the value returned from sql_select_next_val is incremented in 2 in comparison with last value returned. I need it to be incremented in 1.

the code of sql_select_nextval method is the following:

SELECT seq.NEXTVAL val FROM DUAL

the code of sql_2 method is the following:

<dtml-in "sql_select_nextval">

insert into anytable (oid_anytable, name) values (<dtml-var val>, 'john')

<dtml-var sql_delimiter>

select * from anytable where oid_anytable = <dtml-var val>

</dtml-in> Try to remove the "..." around "sql_select_nextval". I do not understand why your code with the "..." works at all.

If this does not solve your problem, you may try: insert into anytable (oid_anytable, name) values (seq.NEXTVAL,'john') <dtml-var sql_delimiter> select * from anytable where oid_anytable = seq.CURVAL That's the code, we use successfully ('CURVAL' may be wrongly spelled, though). Dieter