Dear sir,
I got an error when try to compile the prepared statement:
'declare $age integer; $vcount integer; select count(*) from userTable into $vcount where age >$age'
If it's impossible to use 'into $v' within above select count statement, then I have to write some post processing code in java to get the number of the results after executing above query(which may not be the most optimized way)
Could you give me some tips of how to use select count(*) from userTable into v (a variable)? Thank you.