Hi Oracle APEX Technologists,
First I created one simple procedure which i have mentioned below
----------------------
create or replace procedure insert_in_emp
(
v_empno1 in emp.empno%type,
v_empno2 in emp.empno%type,
v_ename1 in emp.ename%type,
v_ename2 in emp.ename%type,
v_job1 in emp.job%type,
v_job2 in emp.job%type,
v_mgr1 in emp.mgr%type,
v_mgr2 in emp.mgr%type,
v_hiredate1 in emp.hiredate%type,
v_hiredate2 in emp.hiredate%type,
v_sal1 in emp.sal%type,
v_sal2 in emp.sal%type,
v_comm1 in emp.comm%type,
v_comm2 in emp.comm%type,
v_deptno1 in emp.deptno%type,
v_deptno2 in emp.deptno%type
)
as
type nt_empno is table of emp.empno%type;
type nt_ename is table of emp.ename%type;
type nt_job is table of emp.job%type;
type nt_mgr is table of emp.mgr%type;
type nt_hiredate is table of emp.hiredate%type;
type nt_sal is table of emp.sal%type;
type nt_comm is table of emp.comm%type;
type nt_deptno is table of emp.deptno%type;
v_nt_empno nt_empno := nt_empno(v_empno1, v_empno2);
v_nt_ename nt_ename := nt_ename(v_ename1, v_ename2);
v_nt_job nt_job := nt_job(v_job1, v_job2);
v_nt_mgr nt_mgr := nt_mgr(v_mgr1, v_mgr2);
V_nt_hiredate nt_hiredate := nt_hiredate(v_hiredate1,v_hiredate2);
v_nt_sal nt_sal := nt_sal(v_sal1, v_sal2);
v_nt_comm nt_comm := nt_comm(v_comm1, v_comm2);
v_nt_deptno nt_deptno := nt_deptno(v_deptno1, v_deptno2);
begin
forall i in v_nt_deptno.first .. v_nt_deptno.last
insert into emp(empno, ename, job, mgr, hiredate, sal, comm, deptno)
values(v_nt_empno(i), v_nt_ename(i), v_nt_job(i), v_nt_mgr(i), V_nt_hiredate(i), v_nt_sal(i), v_nt_comm(i), v_nt_deptno(i));
end;
/
------------------
afterwards i inserted two records by invoking that procedure by simple plsql block which i have mentioned below.
-----------------------
begin
insert_in_emp
(
3333,
4444,
'PINKU',
'PINKU1',
'DEV',
'DBA',
7839,
7566,
'15-SEP-2020',
'19-SEP-2020',
2000,
2500,
251,
231,
10,
10
);
end;
/
but i created one form using this procedure which is not allowing to insert row.
i am getting error as "ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'INSERT_IN_EMP' "
i have shared screenshot.please refer.