Introdução 

 SQL Scripts 

 Packages 
 pkg_nkw_exc 
 pkg_nkw_env 
 pkg_nkw_rpl 
 pkg_nkw_std 
 pkg_nkw_app 
 pkg_nkw_spm 
 pkg_nkw_hfs 
 pkg_nkw_sdv 
 pkg_nkw_sys 
 pkg_nkw_obj 
 pkg_nkw_grv 
 pkg_nkw_usr 
 pkg_nkw_cmm 
 pkg_nkw_hlp 
 pkg_nkw_dvp 
 pkg_nkw_dnt_std 
 pkg_nkw_dnt_dvies 
 pkg_nkw_dnt_ccvies 
 pkg_nkw_dnt_logies 
 pkg_nkw_dnt_eppc 
 pkg_nkw_dnt_eapb 
 pkg_nkw_dnt_drmies 
 pkg_nkw_dnt 
 pkg_nkw_drm 
 pkg_nkw_oim 
 pkg_nkw_aud 
 pkg_nkw_dpl 
 pkg_nkw_srw 

 Packages Body 

 Forms 6i 

 Reports 6i 

Linux

 Downloads 
PKG_NKW_OBJ.SPS
Source Package Specification
Estrutura de Objetos.
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;
© 2017 DataPRO Developers