Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Updating a Nested Table

437871Feb 16 2005 — edited Feb 16 2005
I am trying to update a column that is a nested table.

UPDATE TABLE(SELECT NT_ID FROM TB_TEST WHERE TEST_ID = 17353) IM
SET IM.NT_ID = 1;
WHERE IM.ITEM_NO_ID = #####;

Where NT_ID is a field from the nested table and TEST_ID is the Primary Key in my TB_TEST table. When I run this it gives me an error of:
ORA-22908: REFERENCE TO NULL TABLE VALUE

I assume this is because NT_ID is currently NULL, and when it pulls the record back, I am pulling a NULL value. Currently all the values will be NULL, but I would like to create a UPDATE Statement that will update that value from NULL to whatever I want.

Please help?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 16 2005
Added on Feb 16 2005
#general-database-discussions
2 comments
227 views