I’m trying to pass data from one session to another.
This can be different object types.
So we store the data in in an anydata column.
Now I’m trying to change this so we can add multiple data to this procedure.
So I want a procedure with an input of table of anydata.
And then I store this type in a table.
So I can create the type like this:
<code>create type anydatatable as table of anydata;
</code>
<code>create type anydatatable as table of anydata;
</code>
create type anydatatable as table of anydata;
But when I want to store it in a table I get the error:
<code>create table table_any (c1 number, c2 anydatatable )
</code>
<code>create table table_any (c1 number, c2 anydatatable )
</code>
create table table_any (c1 number, c2 anydatatable )
ORA-22913
How can I avoid this problem ? I ready about nested table xxx store as xxx but I can’t get it to work with this example.