Let's say we have a table with two entries:
name nr
----------
foo 1
bar 2
and a C program doing the following:
...
i=1;
exec sql declare C cursor for select name from table where nr=:i;
i=2;
exec sql open C;
...
Which row will be selected?
I guess I'll try Oracle as soon as I find time.
Michael
--
Dr. Michael Meskes meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!