SQL & PL/SQL

Hi All,

Could anybody please help me in identifying the issue in the below code as i am getting error as:

declare
*

ERROR at line 1:
ORA-01006: bind variable does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 846
ORA-06512: at "SYS.DBMS_SQL", line 52
ORA-06512: at line 14

Below is my code :

declare
vSql varchar2(1000);
vSal number(10);
vName varchar2(20) := 'King';
hcur number;
lexe number;
Begin
hcur := dbms_sql.open_cursor;
vSql := 'select salary into :sal from employees where last_name = :name ';
dbms_sql.parse(hcur,vsql,dbms_sql.native);
dbms_sql.bind_variable(hcur,':name',vname);
dbms_sql.bind_variable(hcur,':sal',vSal,10);
lexe := dbms_sql.execute(hcur);
Loop
exit when dbms_sql.fetch_rows(hcur) = 0;
dbms_sql.variable_value(hcur,':sal',vSal);
end loop;
dbms_sql.close_cursor(hcur);
end;