This content has been marked as final. Show 2 replies
Each table type object needs a nested table.
The object: object2 has a nested table object: workobj
So that too needs a nested table clause.
This will create 3 tables:
CREATE TABLE prepop ( ob_id VARCHAR2(20) , object2 t_op_sam_obj ) nested TABLE object2 store AS nested_tab1 ( nested TABLE workobj store AS nested_tab2 ) return as value ;
nested_tab2 as nested table of
nested_tab1 as nested table of