Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (column_name NUMBER(9,2));
CREATE OR REPLACE PROCEDURE spupdate_price_by_cat(
  amount IN table_name.column_name%TYPE
)
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE(amount);
END;
/
BEGIN
  DBMS_OUTPUT.PUT_LINE('Initialising output buffer.');
  spupdate_price_by_cat(123456789.12);
END;
/
1 rows affected

dbms_output:
Initialising output buffer.
123456789.12

CREATE OR REPLACE PROCEDURE spupdate_price_by_cat(
  amount IN table_name.column_name%TYPE
)
AS
  v_amount table_name.column_name%TYPE := amount;
BEGIN
  DBMS_OUTPUT.PUT_LINE(v_amount);
END;
/
BEGIN
  DBMS_OUTPUT.PUT_LINE('Initialising output buffer.');
  spupdate_price_by_cat(123456789.12);
END;
/


dbms_output:
Initialising output buffer.

ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "FIDDLE_UNFNFZTDANRSAGYQDFSF.SPUPDATE_PRICE_BY_CAT", line 5
ORA-06512: at line 3

BEGIN
  DBMS_OUTPUT.PUT_LINE('Initialising output buffer.');
  spupdate_price_by_cat(1234567.12);
END;
/
1 rows affected

dbms_output:
Initialising output buffer.
1234567.12