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