IFS writes the judgment of empty characters in the Oracle script package

zhaozj2021-02-16  112

FUNCTION Get_Machine_Work_Center_No (contract_ IN VARCHAR2, part_no_ IN VARCHAR2, routing_revision_ IN VARCHAR2, bom_type_ IN VARCHAR2, alternative_no_ IN VARCHAR2) RETURN VARCHAR2IS temp_ ROUTING_OPERATION_TAB.work_center_no% TYPE; BEGIN temp_: = ''; temp_: = Get_Work_Center_No (contract_, part_no_, routing_revision_, bom_type_, alternative_no_, 3); if (temp_ = '') then temp_: = Get_Work_Center_No (contract_, part_no_, routing_revision_, bom_type_, alternative_no_, 1); END if; RETURN temp_; END Get_Machine_Work_Center_No;

// Take the work center number, first take the work center of the third process, if you can't get it, take the work center of the first process; found that if there is a third process, it can be taken correctly; if only one The process is not to get it, it is really strange; it is estimated that there is a problem: modifying the following information is correct:

FUNCTION Get_Machine_Work_Center_No (contract_ IN VARCHAR2, part_no_ IN VARCHAR2, routing_revision_ IN VARCHAR2, bom_type_ IN VARCHAR2, alternative_no_ IN VARCHAR2) RETURN VARCHAR2IS temp_ ROUTING_OPERATION_TAB.work_center_no% TYPE; BEGIN temp_: = ''; temp_: = Get_Work_Center_No (contract_, part_no_, routing_revision_, bom_type_, alternative_no_, 3); if (temp_ = '') or (temp_ IS NULL) then temp_: = Get_Work_Center_No (contract_, part_no_, routing_revision_, bom_type_, alternative_no_, 1); END if; RETURN temp_; END Get_Machine_Work_Center_No;

Small problems, also to solve it ...

转载请注明原文地址:https://www.9cbs.com/read-10233.html

New Post(0)