如题
[PHP]
CREATE OR REPLACE PROCEDURE Aoi_Inspect_Autologin_New(
EMP IN VARCHAR2,LINE IN VARCHAR2, SECTION IN VARCHAR2,
W_STATION IN VARCHAR2, EC IN VARCHAR2, DATA IN VARCHAR2,
MYGROUP IN VARCHAR2,RESULT IN VARCHAR2 ,QTY IN VARCHAR2,LCA IN VARCHAR2,
FAIL_FLAG IN VARCHAR2,
RES OUT VARCHAR2
) AS
MO VARCHAR(25);
OK VARCHAR(25);
C_MODEL VARCHAR(25);
p_TYPE VARCHAR(1); --- 2001/11/03
SUM_QTY NUMERIC(6,0);
R_COUNT NUMBER;
R_TYPE VARCHAR(1);
R_PER NUMBER(10,4);
P_POINT_QTY NUMBER(6,0);
C_PERCENTAGE NUMBER(10,4);
GROUP_NUM NUMBER;
COUNT_FLAG VARCHAR(1);
V_DATETIME DATE;
V_WIPCOUNT NUMBER;
V_STEP VARCHAR(10);
V_CUST VARCHAR(10);
V_GRADE VARCHAR(10);
REV VARCHAR(25);
BEGIN
V_DATETIME:=SYSDATE();
MO := '';
OK := 'OK';
RES:='OK';
SELECT MO_NUMBER,MODEL_NAME,CUST_NO,LEVEL_GRADE,VERSION_CODE
INTO MO,C_MODEL,V_CUST,V_GRADE,REV
FROM SFISM4.R_WIP_TRACKING_T
WHERE SERIAL_NUMBER = DATA AND ROWNUM = 1;
[/PHP]