Hi all,
I am working on migration of forms application which includes DB migration from 11g to 12c and Forms migration from 10i to 12c.
DB migration is done by other colleagues and charset in old 11g database was EE8MSWIN1250 and now on 12c is AL32UTF8.
All Forms are just compiled in Forms Builder 12c in database 12c and everything went smooth.
But sometiomes strange exception FRM-12713: ORA-00000 appears:
After some days of debugging I find the reason, but not the solution:
This message appears when database PL/SQL procedure is called which in out parameter returns string which includes the character like "-" (hyphen), but with character code of 14844051. In original 11g database it has character code of 150. This string comes as result of select from specific table in database.
How to solve this? Ok, for specific table I can catch and replace this character, but who knows where in hunderd and so tables similar characters appaear.
Is there some parameter in forms server or in form itself (changing Data Lengt Semanics for forms item does not solve the problem).
The most annoying fact is the text of error, which is confusing for a user.
Regards,
Sašo