質問編集履歴
1
状況更新
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -37,4 +37,74 @@
|
|
|
37
37
|
|
|
38
38
|
end;
|
|
39
39
|
/
|
|
40
|
+
```
|
|
41
|
+
|
|
42
|
+
更新箇所
|
|
43
|
+
```ここに言語を入力
|
|
44
|
+
SQL> create sequence Embulk_Test;
|
|
45
|
+
|
|
46
|
+
順序が作成されました。
|
|
47
|
+
|
|
48
|
+
SQL> select Embulk_Test.nextval from dual;
|
|
49
|
+
|
|
50
|
+
NEXTVAL
|
|
51
|
+
----------
|
|
52
|
+
1
|
|
53
|
+
|
|
54
|
+
SQL> select Embulk_Test.nextval from dual;
|
|
55
|
+
|
|
56
|
+
NEXTVAL
|
|
57
|
+
----------
|
|
58
|
+
2
|
|
59
|
+
|
|
60
|
+
|
|
61
|
+
|
|
62
|
+
<<pl/sql>>
|
|
63
|
+
create or replace trigger embulk_tr
|
|
64
|
+
|
|
65
|
+
after insert on INPUT_TEST for each row
|
|
66
|
+
|
|
67
|
+
DECLARE pragma autonomous_transaction;
|
|
68
|
+
|
|
69
|
+
begin
|
|
70
|
+
|
|
71
|
+
dbms_output.put_line('-------------------------');
|
|
72
|
+
dbms_output.put_line('OracleDB to BigQuery Bulk Insert Start');
|
|
73
|
+
|
|
74
|
+
IF INSERTING THEN
|
|
75
|
+
DBMS_SCHEDULER.CREATE_JOB (
|
|
76
|
+
JOB_NAME => 'Embulk_Test.nextval',
|
|
77
|
+
JOB_TYPE => 'EXECUTABLE',
|
|
78
|
+
JOB_ACTION => 'C:\Users\yazaki\Desktop\embulk\cmd.exe /c C:\Users\yazaki\Desktop\embulk\oracle_to_bigquery.bat',
|
|
79
|
+
start_date => TO_DATE('2018/11/13 00:00:00','yyyy/mm/dd hh24:mi:ss'),
|
|
80
|
+
end_date => TO_DATE('2999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'),
|
|
81
|
+
auto_drop => TRUE,
|
|
82
|
+
enabled => TRUE
|
|
83
|
+
);
|
|
84
|
+
END IF;
|
|
85
|
+
|
|
86
|
+
dbms_output.put_line('OracleDB to BigQuery Bulk Insert End');
|
|
87
|
+
dbms_output.put_line('-------------------------');
|
|
88
|
+
|
|
89
|
+
DBMS_SCHEDULER.DROP_JOB('Embulk_Test.nextval', force => true);
|
|
90
|
+
|
|
91
|
+
end;
|
|
92
|
+
/
|
|
93
|
+
|
|
94
|
+
|
|
95
|
+
|
|
96
|
+
<<業務処理を実行>>
|
|
97
|
+
SQL> exec CRE_SAMPLE_DATA;
|
|
98
|
+
BEGIN CRE_SAMPLE_DATA; END;
|
|
99
|
+
|
|
100
|
+
*
|
|
101
|
+
行1でエラーが発生しました。:
|
|
102
|
+
ORA-23306: スキーマEMBULK_TESTが存在しません。
|
|
103
|
+
ORA-06512: "SYS.DBMS_ISCHED", 行175
|
|
104
|
+
ORA-06512: "SYS.DBMS_SCHEDULER", 行288
|
|
105
|
+
ORA-06512: "SYSTEM.EMBULK_TR", 行9
|
|
106
|
+
ORA-04088: トリガー'SYSTEM.EMBULK_TR'の実行中にエラーが発生しました
|
|
107
|
+
ORA-06512: "SYSTEM.CRE_SAMPLE_DATA", 行23
|
|
108
|
+
ORA-06512: 行1
|
|
109
|
+
|
|
40
110
|
```
|