Multiple choice technology databases

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?

  1. When declaring arguments length is not allowed.

  2. When declaring arguments each argument must have a mode specified.

  3. When declaring arguments each argument must have a length specified.

  4. When declaring a VARCHAR2 argument it must be specified.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL stored procedure declarations, formal parameters must specify only the data type (e.g., VARCHAR2), and defining a specific length (like VARCHAR2(30)) is syntactically illegal.

Keep practicing — related questions