header.sql

oracle dal gen,生成.NET ORACLE DAL层代码

create or replace PACKAGE PKG_GEN AS

  g_version constant varchar2(200) := '1.0a';

  type string_list is table of clob;

  function get_version return varchar2;

  function generate_merge_procedure(p_table_name in varchar2) return clob;
  function generate_select_function(p_table_name in varchar2, p_order_by_columns in varchar2 default null) return clob;
  function generate_delete_procedure(p_table_name in varchar2) return clob;

  function generate_package(p_table_name in varchar2, p_package_name in varchar2) return clob;
  function generate_package_body(p_table_name in varchar2, p_package_name in varchar2) return clob;
  
  function get_procedure_params(
                p_table_name in varchar2, 
                p_prefix in varchar2 default null, 
                p_postfix in varchar2 default null,       
                p_delimiter in varchar2 default ', ',
                p_pk in integer default 0,
                p_fk in integer default 0) return varchar2;
                
END PKG_GEN;