Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

My load to enter Users (Define Users form) fails with a Post insert trigger error, why?

0
Posted

My load to enter Users (Define Users form) fails with a Post insert trigger error, why?

0

A. All user names must be in upper case. If they are not then this error occurs. Where Oracle converts data manually entered in a form to upper case then the data entered with forms playback should also be in that format. Q. My load randomly fails and Oracle crashes. A. If your database uses the Unicode UTF-8 character set certain characters may cause the load to fail because they will have been saved in your local character set and are not compatible with UTF8. For example, €, ä, å, æ and ü are also represented differently in UTF-8 compared to the Windows European character sets. By default DataLoad processes data in your local Windows character set. For compatibility with UTF-8 systems the UTF-8 option must be turned on in DataLoad. That is described here.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123