This discussion is archived
4 Replies Latest reply: Feb 25, 2013 3:05 AM by Irha10 RSS

apex process inserting multiple row

Irha10 Newbie
Currently Being Moderated
hi,

i have a process on my page which inserting some tables. one table may have more than one row. say

id1, id2, attr1, desc
1 1001, 1, abc
2, 1001, 4, xyz
3, 1001, 5, hhh

so on. id2 is a fk key in this table. for same id2 it may have more than one row.

i have process and following is part of it but getting error that is PLS-00224: object 'P30_QUES' must be of type function or array to be used this way .

declare
v_count number;
v_code number;

begin

select count(*) into vv_count from table1; -- it may have 7 or 8 questions

FOR i IN 1 .. v_count LOOP

select code into v_code from table1 where code = :p30_ques(i);

if :p30_ques(i) is not null then
INSERT INTO table2 (id1, id2, attr1, desc)
values (null,fk_value, v_code,nvl(:p30_ques(i),null));
end if;
commit;
end loop;
end;

i appriciate your help!
thx

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points