ÇóÖú oracle ´æ´¢¹ý³Ì µ÷ÊÔ

SQL code:

declare
-- Non-scalar parameters require additional processing
psid proaddproductvolume.string_array;
integral proaddproductvolume.int_array;
integralstartdate proaddproductvolume.string_array;
integralenddate proaddproductvolume.string_array;
p_ret proaddproductvolume.int_array;
begin
-- Call the procedure

proaddproductvolume.addproductvolume(cid => :cid,
psid => psid,
integral => integral,
integralstartdate => integralstartdate,
integralenddate => integralenddate,
p_ret => p_ret);
end;


ÎÒÏÖÔÚ½¨ÁËÒ»¸öµ÷ÊÔÄ£¿é µ«ÊDz»ÖªµÀÔõô¸³Öµ....ÉÏÃæµÄ×ֶγýÁË cid ²»ÊÇÒÔÊý×éµÄÐÎʽ´«µÝ ÆäËûµÄ×ֶζ¼ÊÇÒÔÊý×éµÄÐÎʽ´«µÝ½øÀ´µÄ

---

integral[0] := 1;
integral[1] := 2;

È»ºó½« integral ´«Èë²»¿ÉÒÔÂð£¿

---

ÒýÓÃ

integral[0] := 1;
integral[1] := 2;

È»ºó½« integral ´«Èë²»¿ÉÒÔÂð£¿

ͬÒâ¡£

---

ͬÒâ1Â¥·½·¨£¬¿ÉÐÐ

---

ÒýÓÃ

SQL codedeclare-- Non-scalar parameters require additional processing  psid proaddproductvolume.string_array;
  integral proaddp