create or replace package pkg_nkw_obj timestamp '2006-07-07:10:10:10' is ------------------------------------------------------------------ -- 2006 DataPRO Developers - m@urelio ------------------------------------------------------------------ -- Version: 2.0.2 ------------------------------------------------------------------ -- Collections, Records, Variables, Constants, Exceptions, Cursors ------------------------------------------------------------------ type rec_data is record(table_name varchar2(30), column_id number(4), column_name varchar2(30), data_type varchar2(10), data_length number(6), date_value date, number_value number, varchar2_value pkg_nkw_env.gv_char%TYPE); type tab_data is table of rec_data index by binary_integer; gt_data tab_data; ------------------------------------------------------------------ -- GET_SEQUENCE ------------------------------------------------------------------ function get_sequence(fv_name in varchar2) return integer; ------------------------------------------------------------------ -- GET_COLUMNS ------------------------------------------------------------------ function get_columns(fv_table in varchar2) return gt_data%TYPE; ------------------------------------------------------------------ -- INDEX_OF ------------------------------------------------------------------ function index_of(ft_table in gt_data%TYPE, fv_column in varchar2) return binary_integer; ------------------------------------------------------------------ -- CONTENTS_OF ------------------------------------------------------------------ procedure contents_of(ft_data in gt_data%TYPE, fv_data out varchar2); end pkg_nkw_obj; / show errors