Write a PL/SQL procedure to perform withdraw operation that only permits a withdrawal, if there is sufficient funds in the account then update the Account table and print the message, 'Transaction successful.' else print, 'Insufficient Amount'. T...

Last Post

RSS

Posts: 1

Rahul U

Guest

Aug 08, 2020 11:03 pm

(@Rahul U)

Joined: 4 months ago

Please check the attachment for additional information.

Topic Tags

withdrawamountprocedure

2 Replies

Posts: 42

Sambit S

Guest

Aug 08, 2020 11:22 pm

(@Sambit S)

Joined: 4 months ago

You can try the below procedure.

Create or replace procedure
withdraw(acno number, amt number)
Is
V_amt number:=0;
Begin
Select Balance into v_amt
From account
Where accno = acno;

If amt < v_amt then

Update account
Set balance = balance -amt
Where accno = acno;
Commit;

dbms_output.put_line('Transaction Successful');

Else
dbms_output.put_line('Insufficient balance');

End if;

Exception
When others then
Rollback;

End;

1 Reply

Rahul Updhyay

(@rahul)

Joined: 4 months ago

Active Member

Posts: 17

Aug 09, 2020 9:59 am

@Sambit S only 1 test case is passed