Forum Discussion

Juergen's avatar
Juergen
Occasional Contributor
17 years ago

Groovy Script SQL - Problems with the assignment of variables

I have the following problem I liked to select from a data bank a Sequence TEST_CASE_ID_SEQ and write this afterwards in another table. Unfortunately, the handing over of the variable TEST_CASE_ID_SE...
omatzura's avatar
omatzura
Super Contributor
17 years ago
Hi Juergen,

I think the problem is the statement

//READ next Value of TEST_CASE_ID_SEQ
TEST_CASE_ID = sql.eachRow("SELECT TEST_CASE_ID_SEQ.nextval as TEST_CASE_ID_SEQ from dual")
{
}

please try the following instead:

sql.eachRow("SELECT TEST_CASE_ID_SEQ.nextval as TEST_CASE_ID_SEQ from dual")
{
    row -> TEST_CASE_ID = row[0]
}

Hope this helps!

regards,

/Ole
eviware.com