[GENERAL] EXECUTE command in stored procedure

[Arunagiri K]

Dear All,

How can I use EXCEUTE command in stored procedures?
When using like this

EXECUTE 'SELECT INTO REGNO REG_NO FROM ADMISSION WHERE SNAME = ' || STUDNAME ;

STUDNAME is a local variable;

I am getting error like this

ERROR:  syntax error at or near "INTO" at character 8

How can I solve this.

Regards,
Arunagiri.K