> ok,
>
> But the result you get was what I have expected from your query.
>
> Did I miss something ?
>
> What result do you think will be the correct ?
>
> see you !

I expected the procedure would be evaluated just one time using the
first parameter it received, giving me the following result:

TEST_ID FIELD1 TEST
============ ============ ============

1 1 1
1 1 1
2 2 1
2 2 1
3 3 1
3 3 1

Instead of the actual bevahior:

TEST_ID FIELD1 TEST
============ ============ ============

1 1 1
1 1 1
2 2 2
2 2 2
3 3 3
3 3 3

Note that i had a good surprise with the actual behavior. It fits all
my needs. I just want to confirm it's expected to start to use and
abuse it!

Best regards,

Fabiano.