ORA-01485: compile bind length different from execute bind length
i am trying to execute the following procedure from .Net,i am passing two arrays of size 10 as parameters and i recievw the error
ORA-01485: compile bind length different from execute bind length.
can anyone help me please i cant figure out where exactly i am doing wrong.
type t_seq is table of test_approvals.id_seq%type index by pls_integer;
type t_id is table of test_approvals.test_id%type index by pls_integer;
procedure bulk_test(p_seqs in t_seq, p_ids in t_id) is
begin
forall i in p_seqs.first .. p_ids.last
insert into test_approvals
(id_seq, test_id)
values
(p_seqs(i), p_ids(i));
commit;
end bulk_test;
Thanks
Goutham