Dear Friends
We designed the classic report with check box to select the data and copy to another table everything well but getting stop while running the program . My Field is in Numeric even i declared the var as Number but in classic report item type shows as plain text.
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
How to solve this issue kindly suggest.
Declare
doc1 number(10);
begin
for i in 1..apex_application.g_f01.count loop
doc1:= apex_application.g_f20(i);
--raise_application_error(-20001,apex_application.g_f20(i));
insert into test (docno) values (apex_application.g_f01('doc1'));
end loop;
end;
sanjay