PL/SQL (MOSC)

MOSC Banner

ORA-01407: cannot update ("IUM"."TELSXTOWNCODE"."TOWNCODE") to NULL

edited Aug 22, 2014 12:30PM in PL/SQL (MOSC) 4 commentsAnswered ✓

Hi experts.

I have the following problem, if you can help.

ORA-01407: cannot update ("IUM"."TELSXTOWNCODE"."TOWNCODE") to NULL

This is the script:

update ium.TELSXTOWNCODE t

set t.TOWNCODE = (select TOWNCODE from test t2 where t.dn = t2.dn)

test table:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> desc test

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

DN                                        NOT NULL VARCHAR2(10)

TOWNCODE                                  NOT NULL VARCHAR2(5)

STATUS                                             VARCHAR2(5)

desc  ium.TELSXTOWNCODE

SQL> desc  ium.TELSXTOWNCODE

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center