|
OWB(Ошибка в пакетах после генерации)
#33205888
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: SpB->Msk->...
Сообщения: 9 088
|
|
у меня эта процедура выглядит так
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
PROCEDURE Initialize("OUTPUT1" IN NUMBER DEFAULT NULL, p_env IN WB_RT_MAPAUDIT.WB_RT_NAME_VALUES) IS
BEGIN
get_selected := 0 ;
get_inserted := 0 ;
get_updated := 0 ;
get_deleted := 0 ;
get_merged := 0 ;
get_errors := 0 ;
get_abort := FALSE;
FOR i IN 1 ..p_env.COUNT LOOP
IF p_env(i).param_value IS NOT NULL THEN
IF p_env(i).param_name = 'MAX_NO_OF_ERRORS' THEN
get_max_errors := p_env(i).param_value;
ELSIF p_env(i).param_name = 'COMMIT_FREQUENCY' THEN
get_commit_frequency := p_env(i).param_value;
ELSIF p_env(i).param_name = 'OPERATING_MODE' THEN
get_operating_mode := p_env(i).param_value;
ELSIF p_env(i).param_name = 'BULK_SIZE' THEN
get_bulk_size := p_env(i).param_value;
ELSIF p_env(i).param_name = 'AUDIT_LEVEL' THEN
get_audit_level := p_env(i).param_value;
ELSIF p_env(i).param_name = 'AUDIT_ID' THEN
get_audit_id := p_env(i).param_value;
ELSIF p_env(i).param_name = 'PURGE_GROUP' THEN
get_purge_group := p_env(i).param_value;
END IF;
END IF;
END LOOP;
-- Mapping input parameter global variable assignments
DW$FINORG_STRUCT_TF_MAP."OUTPUT1" := DW$FINORG_STRUCT_TF_MAP.Initialize."OUTPUT1";
IF NOT (get_audit_level = AUDIT_NONE) THEN
get_runtime_audit_id := WB_RT_MAPAUDIT.audit_begin(
p_auditid=>get_audit_id,
p_lob_uoid=>get_lob_uoid,
p_lob_name=>get_model_name,
p_purge_group=>get_purge_group,
p_parent=>NULL,
p_source=>'*',
p_source_uoid=>'*',
p_target=>'"DW$FIN_ORG_STRUCT"',
p_target_uoid=>'08649525E9924A3880659DFB52B3E516',
p_info=>NULL,
p_date=>get_cycle_date
);
END IF;
COMMIT;
END Initialize;PROCEDURE Initialize("OUTPUT1" IN NUMBER DEFAULT NULL, p_env IN WB_RT_MAPAUDIT.WB_RT_NAME_VALUES) IS
BEGIN
get_selected := 0 ;
get_inserted := 0 ;
get_updated := 0 ;
get_deleted := 0 ;
get_merged := 0 ;
get_errors := 0 ;
get_abort := FALSE;
FOR i IN 1 ..p_env.COUNT LOOP
IF p_env(i).param_value IS NOT NULL THEN
IF p_env(i).param_name = 'MAX_NO_OF_ERRORS' THEN
get_max_errors := p_env(i).param_value;
ELSIF p_env(i).param_name = 'COMMIT_FREQUENCY' THEN
get_commit_frequency := p_env(i).param_value;
ELSIF p_env(i).param_name = 'OPERATING_MODE' THEN
get_operating_mode := p_env(i).param_value;
ELSIF p_env(i).param_name = 'BULK_SIZE' THEN
get_bulk_size := p_env(i).param_value;
ELSIF p_env(i).param_name = 'AUDIT_LEVEL' THEN
get_audit_level := p_env(i).param_value;
ELSIF p_env(i).param_name = 'AUDIT_ID' THEN
get_audit_id := p_env(i).param_value;
ELSIF p_env(i).param_name = 'PURGE_GROUP' THEN
get_purge_group := p_env(i).param_value;
END IF;
END IF;
END LOOP;
-- Mapping input parameter global variable assignments
DW$FINORG_STRUCT_TF_MAP."OUTPUT1" := DW$FINORG_STRUCT_TF_MAP.Initialize."OUTPUT1";
IF NOT (get_audit_level = AUDIT_NONE) THEN
get_runtime_audit_id := WB_RT_MAPAUDIT.audit_begin(
p_auditid=>get_audit_id,
p_lob_uoid=>get_lob_uoid,
p_lob_name=>get_model_name,
p_purge_group=>get_purge_group,
p_parent=>NULL,
p_source=>'*',
p_source_uoid=>'*',
p_target=>'"DW$FIN_ORG_STRUCT"',
p_target_uoid=>'08649525E9924A3880659DFB52B3E516',
p_info=>NULL,
p_date=>get_cycle_date
);
END IF;
COMMIT;
END Initialize;
|
|
|
