Skip to Main Content

Oracle Apex - pl/sql code for copy data from 1 table to another

SANPATJul 11 2022

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

This post has been answered by SANPAT on Jul 11 2022
Jump to Answer
Comments
Post Details
Added on Jul 11 2022
3 comments
12 views