----存储过程 INSERT_MAT_ID_PROCEDURE实例
create or replace procedure INSERT_MAT_ID_procedure (IN_PRD_PLAN_ID IN VARCHAR2,IN_MAT_ID IN VARCHAR2 ,results out varchar2)
IS
v_str FLOAT;
v_count number(10);
v_results VARCHAR2(2000);
v_order_num VARCHAR2(20);
v_ORDER_ITEM_NUM VARCHAR2(20) default '-1';
CURSOR ORDER_ITEM_NUM(v_PRD_PLAN_ID VARCHAR2)
IS
SELECT ORDER_ITEM_NUM
FROM SC_ORDER_PLAN
WHERE PRD_PLAN_ID = v_PRD_PLAN_ID;
CURSOR SC_PLAN_DETAIL_standard(v_IN_MAT_ID VARCHAR2)
IS
SELECT PRD_STANDARD
FROM SC_PLAN_DETAIL SPD
WHERE SPD.MAT_ID = (SELECT SP.PRD_PLAN_PRODUCTION_PRD_ID
FROM