Fixed #22669 -- Fixed QuerySet.bulk_create() with empty model fields on Oracle.

1 files changed, 24 insertions, 0 deletions

diff --git a/django/db/backends/oracle/utils.py b/django/db/backends/oracle/utils.py
index f958655f94..6c81d5cd7b 100644
--- a/django/db/backends/oracle/utils.py
+++ b/django/db/backends/oracle/utils.py
@@ -29,3 +29,27 @@ class Oracle_datetime(datetime.datetime):
             dt.year, dt.month, dt.day,
             dt.hour, dt.minute, dt.second, dt.microsecond,
         )
+
+
+class BulkInsertMapper:
+    BLOB = 'TO_BLOB(%s)'
+    DATE = 'TO_DATE(%s)'
+    INTERVAL = 'CAST(%s as INTERVAL DAY(9) TO SECOND(6))'
+    NUMBER = 'TO_NUMBER(%s)'
+    TIMESTAMP = 'TO_TIMESTAMP(%s)'
+
+    types = {
+        'BigIntegerField': NUMBER,
+        'BinaryField': BLOB,
+        'DateField': DATE,
+        'DateTimeField': TIMESTAMP,
+        'DecimalField': NUMBER,
+        'DurationField': INTERVAL,
+        'FloatField': NUMBER,
+        'IntegerField': NUMBER,
+        'NullBooleanField': NUMBER,
+        'PositiveIntegerField': NUMBER,
+        'PositiveSmallIntegerField': NUMBER,
+        'SmallIntegerField': NUMBER,
+        'TimeField': TIMESTAMP,
+    }