Forum Stats

  • 3,824,912 Users
  • 2,260,439 Discussions
  • 7,896,344 Comments

Discussions

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

L_a_u_r_a
L_a_u_r_a Member Posts: 11 Green Ribbon
edited Jun 17, 2022 1:26PM in SQL Developer

I get this error sometime in a report in APEX. The application passes 2 parameters with a date data type,  to_date(:P1_FROM_DATE, 'DD-MON-YYYY' ) and  to_date(:P1_TO_DATE, 'DD-MON-YYYY' ). The Page items are Date Pickers with a format mask DD-MON-YYYY. They are passed into a package that creates a table. I then query the table in APEX to get the report. The error doesn't seem consistent which is making it difficult to find the cause. If I pick dates in December, I get results. If I pick dates in June, I get the error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error.