CREATE OR REPLACE PROCEDURE nowa_lokata (acc_id NUMBER, VALUE NUMBER) IS
BEGIN
DECLARE
bal NUMBER;
BEGIN
SELECT balance INTO bal FROM ACCOUNTS WHERE account_id=acc_id;
BEGIN
IF VALUE < bal THEN
    INSERT INTO deposits
    VALUES (
    (SELECT MAX(deposit_id)+1 FROM deposits WHERE ACCOUNT_NUMBER= acc_id),acc_id , VALUE,  ( SELECT CURRENCY FROM accounts
    WHERE account_id = acc_id ), 4 ,SYSDATE  );
    UPDATE accounts
    SET balance = balance - VALUE
    WHERE account_id = acc_id;
END IF;
END;
END;
END nowa_lokata;