create procedure ChangePassword(@sUser char(20),@sPassword char(20))
execute immediate 'GRANT CONNECT TO ' + @sUser + ' IDENTIFIED BY ' + @sPassword
grant execute on ChangePassword to public
I m getting syntax error at '+' sign. I saw in BOL and it is exactly the same.
Can nyone help me out?