Atribute update in SDE Feature Class ora-02005: implicit (-1)

anilkumar — Thu, 15 Dec 2011 06:23:27 GMT

I am getting an error while editing a feature class details in Arcmap.

attribute update: An unexpected failure occured.
Underlying dbms error [ora-02005: implicit (-1) length not valid for this bind or define datatype]
[sde.featureclassxxx]

I am using ArcGIS/ArcSDE 10 with Oracle 10.2.0.4.0

Though its database related error, the reason for posting here that i might get pointers to direct from SDE point of view.

TIA,

Re: Atribute update in SDE Feature Class ora-02005: implicit (-1)

VinceAngelo — Thu, 15 Dec 2011 10:21:22 GMT

That's an unusual error. Did you change the structure of the table after it was registered
with ArcSDE?

You *REALLY* shouldn't create or edit any table as the SDE user. SDE should be treated as
a privileged account like SYSTEM or MDSYS, and only used for ArcSDE administration. Best
practice is to create one or more tablespaces to contain your data, and one or more data
management users to own and manipulate the data. You are infinitely more likely to damage
your instance when you use the SDE user for non-administrative purposes.

- V

topic Re: Atribute update in SDE Feature Class ora-02005: implicit (-1) in Data Management Questions

Atribute update in SDE Feature Class ora-02005: implicit (-1)

Re: Atribute update in SDE Feature Class ora-02005: implicit (-1)