Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist

gzh  <gzhcoder@126.com> writes:
> Thank you for your prompt reply. 
> Is there another solution if the database is not upgraded to 12.14?

The solution is the same whether you upgrade or not: you need
to adjust your search_path to include the "oracle" schema,
or else explicitly qualify references to orafce functions.

            regards, tom lane