[Home] [Help]
616: SELECT
617: TEXT_CODE
618: INTO TEXTCODE
619: FROM
620: GMD_SPECIFICATIONS_B
621: WHERE SPEC_ID = QC_SPEC_ID;
622: RETURN (TEXTCODE);
623: RETURN NULL;
624: EXCEPTION
631: SELECT
632: TEXT_CODE
633: INTO TEXTCODE1
634: FROM
635: GMD_SPECIFICATIONS_B
636: WHERE SPEC_ID = QC_SPEC_ID2;
637: RETURN (TEXTCODE1);
638: RETURN NULL;
639: EXCEPTION