SQL Stored Procedure adding values to table run successful, but no result show in the table

Question

I have created a stored procedure in SQL Server to add new student record to Student table. I have grant permission to one of the roles I created that is "DBAdmins". I have also login as "DBAdmins" and run the store procedure successfully, it returns 1 row affected. But when I select * from student table, it has nothing in the table. Below is the stored procedure I created and the execute command run from DBAdmins.

I have tried run the execute command, try "INSERT INTO" command, but nothing is working. There is no result in the student table.

Store Procedure

CREATE PROCEDURE dbo.AddNewStudent
    @StudentID VARCHAR(6),
    @TempPassword VARCHAR(100),
    @Name VARCHAR(100),
    @Phone VARCHAR(20)
AS
BEGIN
    OPEN SYMMETRIC KEY PasswordEncryptionKey
    DECRYPTION BY CERTIFICATE AISServerCert;

    INSERT INTO dbo.Student (ID, SystemPwd, Name, Phone)
    VALUES (
        @StudentID, 
        EncryptByKey(Key_GUID('PasswordEncryptionKey'), @TempPassword),
        @Name, 
        @Phone
    );

    CLOSE SYMMETRIC KEY PasswordEncryptionKey;
END;
GO

Execute Command

EXEC dbo.AddNewStudent
    @StudentID = 'ST1001',
    @TempPassword = 'TP0001@1234',
    @Name = 'John Doe',
    @Phone = '012-2148759';