[sql] 1
Viewer
- CREATE
- OR REPLACE PROCEDURE STAGE.VAL_CHECK_BD_CB_P( IN_BRANCH IN NUMBER,
- IN_START_DATE IN DATE,
- IN_END_DATE IN DATE,
- OUT_MESSAGE OUT VARCHAR2(100) ) AS V_CNT NUMBER; BEGIN /****************************************************************************** NAME: VAL_CHECK_BD_CB_P PURPOSE: Процедура сверки с БД ЦБ ******************************************************************************/ /*проверяем,
- что данные есть*/SELECT COUNT(*) INTO V_CNT
- FROM OFSA_OWNER.ACC_ACCOUNT AC
- WHERE AC.ACCD_BRANCH_DEPT_GID = IN_BRANCH
- AND AC.ACCD_AS_OF_DATE
- BETWEEN IN_START_DATE
- AND IN_END_DATE; IF V_CNT = 0 THEN
- OUT_MESSAGE := 'Нет данных';
- ELSE
- END IF; END; /
Editor
You can edit this paste and save as new: