Print Thread
How to update an object type field?
#63939 05/17/22 11:42 PM
Joined: Feb 2003
Posts: 126
Portland, OR. USA
F
fidelfs Offline OP
Member
OP Offline
Member
F
Joined: Feb 2003
Posts: 126
Portland, OR. USA
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]

Re: How to update an object type field?
fidelfs #63941 05/18/22 08:27 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
It is currently indeed not possible to update collection type columns in the result grid of the SQL Window. This is on the list of enhancement requests though.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 15 (0.007s) Memory: 2.4986 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-29 01:22:16 UTC
Valid HTML 5 and Valid CSS