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
Post a Comment