getting ORA-01438 error (field presion) on update from fields of the same presision [message #327249] |
Sun, 15 June 2008 12:26  |
dan_thorman
Messages: 14 Registered: January 2007
|
Junior Member |
|
|
hi.
I am running an update statement that is updating a field in a table from a field in a view. BOTH FIELDS are defined as number(6). however, when i try to set field a equal to field b, i get this error: ORA-01438: value larger than specified precision allowed for this column
the fields are defined as below:
table a:
prop_id number (6)
prop2_id number (6)
VIEW b:
prop_id number(6)
prop2_id number (6)
i fail on this:
update a
set a.prop2_id = (select b.prop2_id from b where b.prop_id = a.prop_id)
suggestions?
|
|
|
|
|