Kbase P116716: What is the column name associated with error ORA-01438?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/07/2006 |
|
Status: Unverified
GOAL:
What is the column name associated with error ORA-01438?
GOAL:
Is it possible to programmatically find out the name of the offending column when getting the error "ORA-01438: value larger than specified precision allows for this column"?
FACT(s) (Environment):
Oracle DataServer
Oracle
FIX:
When running a Progress 4GL Application against an ORACLE DB, one might get the following error message:
"ORA-01438: value larger than specified precision allows for this column"
Unfortunately, it is not possible to programmatically find out the name of the offending column when getting this error. Since the information is not in the error message text, one can only try to examine the SQL generated and see if it helps narrowing it down.