write plsql with auto

CREATE OR REPLACE PROCEDURE insert_sal(
p_name IN VARCHAR2,
p_salary IN NUMBER
) IS
v_empid VARCHAR2(7);
v_seq_num NUMBER;
BEGIN
-- Generate the sequence number
SELECT empid_seq.NEXTVAL INTO v_seq_num FROM dual;

-- Concatenate with the letter part (assuming 'AB' as the prefix)
v_empid := 'AB' || TO_CHAR(v_seq_num, 'FM00000');

-- Insert into the sal table
INSERT INTO sal (empid, name, salary)
VALUES (v_empid, p_name, p_salary);

-- Commit the transaction
COMMIT;

EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RAISE;
END;