Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

L_a_u_r_aJun 17 2022 — edited Jun 17 2022

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.

Comments

mdtaylor

You can only do this if the application tiers on both source and target are identical, i.e. have the exact same patches and code migrations in any custom tops.

If that is the case, you can refresh the DB only, still execute fnd_conc_clone.setup_clean, then run autoconfig from DB tier, patch FS, then run FS.  Autoconfig will not complete successfully on the patch FS, but it will still populate ad_appl_top and tns tables.

1 person found this helpful
1 - 1

Post Details

Added on Jun 17 2022
#sql-developer
0 comments
878 views