Hi All,
When I try to create record as schema level, I get error. So, isn't it SQL type?
create or replace type rec_t is record
(
col1 number,
col2 number
);
My second question is, why I cannot create table rowtype when I create collection as below?
create table test_table
(
id number primary key,
txt varchar2(5)
);
create or replace type my_arr is table of test_table%rowtype;
- Error(1,25): PLS-00329: schema-level type has illegal reference to HR.TEST_TABLE
Thanks in advance