PLSQL record created with %rowtype being used as element for table gives compile/run error -


i declaring table custom data-type of record , record created %rowtype of table nemed : tmp_unregister_tab , table exists in db . while trying execute below plsql anon block error specified below.

plsql code:

declare   rec_tmp_tab tmp_unregister_tab%rowtype ;   v_rec_tmp_tab rec_tmp_tab;   type tab_rec_tmp table of v_rec_tmp_tab%type   index binary_integer;      v_tab_rec_tmp tab_rec_tmp; begin   null;   end;  / 

script output:

error report: ora-06550: line 3, column 18: pls-00488: 'rec_tmp_tab' must type ora-06550: line 3, column 18: pl/sql: item ignored ora-06550: line 4, column 33: pls-00320: declaration of type of expression incomplete or malformed ora-06550: line 4, column 4: pl/sql: item ignored 06550. 00000 -  "line %s, column %s:\n%s"  *cause:    pl/sql compilation error. *action: 

declare   rec_tmp_tab tmp_unregister_tab%rowtype ;   type tab_rec_tmp table of tmp_unregister_tab%rowtype    index binary_integer;      v_tab_rec_tmp tab_rec_tmp; begin   null; end; / 

Comments