For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hi am in oracle database 11g i have the following block
v_emp varchar2 := to_number(:vinput);
begin
select v_emp from dual;
end;
am geting error ORA-06502: PL/SQL: numeric or value error: character to number conversion error