Dear all,
is it possible to create a record of collection in schema level using %ROWTYPE? I try to do this:
SQL> create or replace type some_type is table of hr.employees%rowtype;
2 /
Warning: Type created with compilation errors.
SQL> sho err
Errors for TYPE SOME_TYPE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/31 PLS-00329: schema-level type has illegal reference to
HR.EMPLOYEES
I was complaining about "illegal reference to the table hr.employees (I used sample hr schema). Any ideas?
best regards,
Val