A.
exec sql select Sname ,Sage into vSname,vSage from student where Sname=vSpecname
B.
exec sql select Sname ,Sage into :vSname,:vSage from student where Sname=:vSpecname
C.
select Sname ,Sage into :vSname,:vSage from student where Sname=:vSpecname
D.
exec sql :vSname,:vSage from student where Sname=:vSpecname