Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01485: compile bind length different from execute bind length

667699Oct 29 2008
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Oct 29 2008
0 comments
632 views