The parameternum_rows_in is defined asnumber(32,0). You should usenumber` without precision in this context to make the code compile.

See good and bad example inhttps://github.com/Trivadis/plsql-and-sql-coding-guidelines/blob/v4.1/docs/4-language-usage/7-stored-objects/9-sql-macros/g-7910.md