Hi,

I wanted to select more fields of a select statement into variables, but I saw that this was not possible doing this

select mt.firstfield into var1,mt.secondfield into var2,mt.thirdfield into var3
from my_table mt

How can i do this??

thanks
edli