▼I got an anwser to this qeustion ▼ DECLARE l_status BOOLEAN; BEGIN DDPAY_SP(303,l_status); IF l_status = FALSE THEN DBM
Posted: Mon Jul 11, 2022 9:55 am
▼I got an anwser to this qeustion ▼
DECLARE l_status BOOLEAN;BEGINDDPAY_SP(303,l_status);IF l_status = FALSE THENDBMS_OUTPUT.PUT_LINE('False');ELSEDBMS_OUTPUT.PUT_LINE('True');END IF;END;
CREATE OR REPLACE PROCEDURE DDPAY_SP(l_iddonor INNumber,resultCode OUT BOOLEAN)ISCURSOR c1ISSELECT IDSTATUS,PAYMONTHSFROM DD_PLEDGE WHERE IDDONOR=l_iddonor;l_idstatus NUMBER(2);l_paymonths NUMBER(3);
BEGINOPEN c1;LOOPFETCH c1 INTO l_idstatus,l_paymonths;EXIT WHEN c1%NOTFOUND;IF l_idstatus = 20 AND l_paymonths = 0 THENresultCode := FALSE;ELSEresultCode := TRUE;EXIT;END IF;END LOOP;CLOSE c1;
Can I get screenshots of this question? It doesn't workon my laptop
DECLARE l_status BOOLEAN;BEGINDDPAY_SP(303,l_status);IF l_status = FALSE THENDBMS_OUTPUT.PUT_LINE('False');ELSEDBMS_OUTPUT.PUT_LINE('True');END IF;END;
CREATE OR REPLACE PROCEDURE DDPAY_SP(l_iddonor INNumber,resultCode OUT BOOLEAN)ISCURSOR c1ISSELECT IDSTATUS,PAYMONTHSFROM DD_PLEDGE WHERE IDDONOR=l_iddonor;l_idstatus NUMBER(2);l_paymonths NUMBER(3);
BEGINOPEN c1;LOOPFETCH c1 INTO l_idstatus,l_paymonths;EXIT WHEN c1%NOTFOUND;IF l_idstatus = 20 AND l_paymonths = 0 THENresultCode := FALSE;ELSEresultCode := TRUE;EXIT;END IF;END LOOP;CLOSE c1;
Can I get screenshots of this question? It doesn't workon my laptop