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.
for i in 1..apex_application.g_f01.count loop
insert into test (docno) values (apex_application.g_f01('doc1'));