CREATE OR REPLACE PROCEDURE (?????(the array cannot be used ) IN) as You can only use CREATE OR REPLACE PROCEDURE (v_scalr_in IN) as