Examine this procedure:CREATE OR REPLACE PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHER2(30))ISBEGININSERT INTO PLAYER(ID, LAST_NAME)VALUES(V_ID, V_LAST_NAME);COMMIT;END; Why does this command fail when executed?
When declaring arguments length is not allowed.
When declaring arguments each argument must have a mode specified.
When declaring arguments each argument must have a length specified.
When declaring a VARCHAR2 argument it must be specified.