Ora 01401 which column

Information Article Number. Old Article Number. Article Record Type. Solutions to a Product Problem. Problem List of phrases which describe the issue including symptoms in the UI or logs.

Cause Optional - Specific technical discrepancy if known, only if it will help reader determine if the article applies. Solution Numbered list of steps to perform to resolve issue. This knowledge article may contain information that does not apply to version Please refer to Article Number for more information about troubleshooting BMC products in containers.

Log in to post to this feed. Menu Menu. This article describes an error "ORA inserted value too large for column" when performing certain operations against a MicroStrategy metadata in Oracle.

An example of such an operation is the copying of objects into a project in an Oracle metadata using MicroStrategy Object Manager 7. Users should check the character set encoding of the database where the metadata tables are stored. If it is Unicode, then the md7orclutf8. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable.

Question: I have a table with columns and keep receiving ORA when I attempt to put the data in a table with a cursor. Is there any way I can figure out which column is throwing the ORA error? Answer: You should note that in 10g, the error has been updated and includes further information, making it easier to resolve ORA Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.

Feel free to ask questions on our Oracle forum.