Create a procedure named DDPAY_SP that identifies whether a donor currently has a completed pledge with no monthly payments. A donor ID is the input to the procedure. Using the donor ID, the procedure needs to determine whether the donor has any currently completed pledges based on the status field and is/was not on a monthly payment plan. If so, the procedure is to return the Boolean value TRUE. Otherwise, the value FALSE should be returned. Test the procedure with an anonymous block.

Create a procedure named DDPAY_SP that identifies whether a donor currently has a completed pledge with no monthly payments. A donor ID is the input to the procedure. Using the donor ID, the procedure...

Create a procedure named
DDPAY_SP
that identifies whether a donor currently has a completed pledge with no monthly payments. A donor ID is the input to the procedure. Using the donor ID, the procedure needs to determine whether the donor has any currently completed pledges based on the status field and is/was not on a monthly payment plan. If so, the procedure is to return the Boolean value TRUE. Otherwise, the value FALSE should be returned. Test the procedure with an anonymous block.

Jun 08, 2022