oracle中多条数据添加的问题
因为主键的原因，在里面写了个循环，写是写好了，可是传的参数，他不能识别，就是我传的这个P_ITEMID 参数是一个拼接的字符串，如‘12456’，‘54215’，‘54214’....!一次性传50条！为什么不能成功添加呢？求解~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~急用！！！！！！！！

create or replace procedure SP_Insert(
                                            P_ITEMID CHAR,
                                            P_NEWBARGROUPID CHAR,
                                            P_NEWBARID      CHAR,
                                            P_STATUS        CHAR,
                                            P_CREATEUSERID CHAR,
                                            P_CREATEDATE   DATE,
                                            NUM OUT NUMBER) AS
  SQLSTRING VARCHAR2(30000);
  NO        NUMBER;
  CURSOR C2 IS
  SELECT ITEMID,
          COMPANYID,
          RETAILID,
          ORIGINALBARGROUPID,
          ORIGINALBARID
      FROM (SELECT A.COMPANYID  AS COMPANYID,
                   A.RETAILID   AS RETAILID,
                   A.ITEMID     AS ITEMID,
                   A.BARGROUPID AS ORIGINALBARGROUPID,
                   A.BARID      AS ORIGINALBARID
              FROM  A
             WHERE A.LQT77_ITEMID IN (P_LQT72_ITEMID)
   &