Arunagiri K wrote:
> 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
Dear All,How can I use EXCEUTE command in stored procedures?When using like thisEXECUTE 'SELECT INTO REGNO REG_NO FROM ADMISSION WHERE SNAME = ' || STUDNAME ;STUDNAME is a local variable;
I am getting error like thisERROR: syntax error at or near "INTO" at character 8How can I solve this.Regards,A
