ArrayDML and complex types

[BobGeezer]

Hi again Marco,

Trying array DML instead of DPL for simplicity, we get error:

:INSERTDATE is a complex variable and cannot be an array

Does this mean array DML doesn't work for timestamps? If so, is there a remedy in the pipeline please?

...Again, one simple working example of DPL with timestamps would solve all our problems, allowing us to avoid array DML.. Is there one somewhere? Please!!!

 

[Marco Kalter]

You can use Array DML with timestamps, if you pass them as strings, formatted in accordance with the NLS_TIMESTAMP_FORMAT setting of the Oracle Client.