SQL>
SQL> create or replace package body pkg_sync4_ecl is
2procedure fct4_sync(beginDate date, endDate date) is
3rtn varchar2(10);
4begin
5
6ctl_id := pkg_sync4_log.insertctl(ver => 1,
7
p_start_time=> '',
8
p_end_time=> '',
9
start_time=> sysdate,
10
systemversion => '4',
11
schemaname=> 'dps',
12
tablename => '',
13
pkgname => 'pkg_sync4_dps.fct4_
sync',
14
funcname=> '',
15
runStatus => 'RUNNING');
16rtn := fct4_ctry_mst('', '');
17pkg_sync4_log.updatectl(ctl_id=> ctl_id,
18
end_time=> sysdate,
19
runStatus => 'SUCCESS',
20
consumetime => 5,
21
content => 'SUCCESS');
22commit;
23return;
24
25null;
26end;
27
28function fct4_ctry_mst(beginDate varchar2, endDate varchar2)
29return varchar2 is
30rtn varchar2(10);
31-- rowid
32mstid varchar2(10);
33-- row number
34row_count number;
35insertSql varchar(4000);
36cursor cur_ds_ecl3 is
37--select ds.oper_type, ds.old_rowid, ds.new_rowid, ds.rowid ds_rowid
38select *
39
from comn.data_sync_ecl@tdevdb ds;
40-- where ds.sync_sts = 'C';
41-- and ds.TABLE_NAME = 'CTRY_MST';
42r_ds_ecl3 cur_ds_ecl3%rowtype;
43begin
44
45null;
46end;
47
48begin
49null;
50end pkg_sync4_ecl;
51/
create or replace package body pkg_sync4_ecl is
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL>
|