Hi,
Does the UNIDAC and / or ORADAC components support Oracle DML Array functionality.
By DML Array functionality I mean the ability to do multiple DML statements simultaneously, like the FORALL statement in Oracle sql.
If it does, or if there is a way to implement this in code, could you please supply an example.
If not, could you please consider adding this to the component set.
Thanx,
Johan Swart
Oracle FORALL
Re: Oracle FORALL
Hello,
You can use the TOraLoader and TUniLoader components for fast data loading in both ODAC and UniDAC respectively. These components allow data loading in two modes: ImDirect and ImDML. In the ImDirect mode, the Oracle client data loading implementation is used; in lmDML, INSERT queries are generated with parameters executed in packages. The fastest way to load data is to use the lmDirect mode, however, this mode is supported in the OCI connection mode only, the Direct mode allows ImDML data loading only.
You can use the TOraLoader and TUniLoader components for fast data loading in both ODAC and UniDAC respectively. These components allow data loading in two modes: ImDirect and ImDML. In the ImDirect mode, the Oracle client data loading implementation is used; in lmDML, INSERT queries are generated with parameters executed in packages. The fastest way to load data is to use the lmDirect mode, however, this mode is supported in the OCI connection mode only, the Direct mode allows ImDML data loading only.