日期:2014-05-16  浏览次数:20381 次

oracle集合类型
-- Public type declarations
  TYPE tp_insert_line_rec IS RECORD(
    icas_selected_lines_t_id icas_selected_lines_t.icas_selected_lines_t_id%TYPE,
    transactionflow_id       icas_selected_lines_t.transactionflow_id%TYPE,
    transaction_id           icas_selected_lines_t.transaction_id%TYPE,
    ap_company_code          icas_selected_lines_t.ap_company_code%TYPE,
    ap_ic_code               icas_selected_lines_t.ap_ic_code%TYPE,
......

TYPE tp_insert_line_tab IS TABLE OF tp_insert_line_rec INDEX BY BINARY_INTEGER;

  -- Public variable declarations
  tp_inst_line_arry tp_insert_line_tab;