Correct me if I am wrong but SQL procedural language doesn't have supportfor variable declarations?
And
Why does my stored function returns only the first row of the query insteadof the whole set of query?
Kindly educate me :)