PRC_S_SQL_DEBUG_LOG

CREATE OR REPLACE PROCEDURE LBI_SYS_VDF.PRC_S_SQL_DEBUG_LOG
(
    iv_task_name   in     varchar2,
    iv_sql         in     varchar2
)
/** head
  * @name prc_s_sql_debug_log
  * @caption store the sql BICP executed
  * @type log
  * @parameter iv_task_name in varchar2   task name
  * @parameter iv_table_name in varchar2  sql text
  * @description                          store the sql BICP executed
  * @target LBI_SYS_VDF#t_s_sql_debug_log
  * @version 1.0
  * @author  mengfanqing
  * @create-date 2014-05-26
  * @copyright huawei
  */

is
    vi_sql_length          integer;
    vi_max_sql_length      integer;
    vv_sql_text1           varchar2(4000);
    vv_sql_text2           varchar2(4000);