Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02309 atomic NULL violation

321312Mar 18 2003 — edited May 24 2005
there is a table containing a field of object type with attributes att1, att2, att3. When I try to update a record using the following SQL command

update TABLE t
set t.my_type.att1='ANY STRING'
where t.id=10;


ORACLE responds as follows

ORA-02309 atomic NULL violation

I don't understand...!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2005
Added on Mar 18 2003
6 comments
1,175 views