Hi All,
I have a scenario where, i'll create an object type first and then table type of that object then create a nested table. But, getting an error "ORA-38818: illegal reference to editioned object APPS.PARAMOBJECT" while creating a nested table.
Please advice. Below is the step by step scenario:
CREATE TYPE paramobject AS OBJECT
(param_description varchar2(10),
param_val VARCHAR2(10)) ;
/
show error;
CREATE TYPE paramlist AS TABLE OF paramobject ;
/
show error;
create table param_matrix(
subprod_id varchar2(10) ,
col_name varchar2(10) , --- The Parameter Name
col_values paramlist --- Possible values of the parameter for the subprod_id
)
NESTED TABLE col_values STORE AS col_values_tab ;
/
show error;
output:
---------
TYPE paramobject compiled
No Errors.
TYPE paramlist compiled
No Errors.
NESTED TABLE col_values STORE AS col_values_tab
Error at Command Line:54 Column:0
Error report:
SQL Error: ORA-38818: illegal reference to editioned object APPS.PARAMOBJECT
No Errors.
Please assist.