How to update an object type field? - Allround Automations forums

I have a table that has a collection type for one field.

SQL Query

Create Type Tms_DCS as table of varchar2(100);

SQL Query

-- Create table
create table STORE_PROCESSING_EXCEPTIONS
(
  run_date_exception         date default on null sysdate not null,
  dcs_running_exception_date tMS_DCS,
  run_date_num_exception     number
)
nested table dcs_running_exception_date store as TMS_DCS_EXCEPTION_DATE_TAB2;

I can do this in TOAD. I know this is a different product, but I think this is possible.
I have the following query to update the values:

SQL Query

Select rowid, A.* from store_processing_exceptions a;

I ran the query, Open the lock icon. I am able to update any field, but the dcs_running_exception_date.
I click the collection field after opening the lock icon. It opens a new table with only the values inside the collection. The lock icon in the collection tab is grey out.

I can do it with an update statement, but I thought this will be trivial using the PLSQL developer functionality.

[video:youtube]https://i.imgur.com/tT9uwGj.mp4[/video]