Oracle bind variable issue

Question

I tried to execute below oracle insert script from SQL developer using a function by passing '0002'.i am expecting some data as output but query return 0 rows inserted.if pass null as input parameter it is inserting some row.input paramter is varchar2

Insert into a.table_name (Select a,b,c from table (a.function(:input)))

Function will return output as table type Note:recently there is an update from 11g to 19c