Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APPEND_VALUES hint in place of SYS_DL_CURSOR for OCI direct path load

3207976Oct 5 2017

Hi,

While using OCI direct path load SYS_DL_CURSOR hint is implicitly getting added Is there a way to add APPEND_VALUES hint to for OCI direct path load? Note that we are not not passing the query in Direct Path context , we only pass the table name and the data stream.SYS_DL_CURSOR stream seems to be getting added by default. It has been found that SYS_DL_CURSOR takes up more space and less performant than APPEND_VALUES hint for direct path load.Please attach a sample program to  use APPEND_VALUES hint through OCI dpl LIBRARIES

Thanks & regards,

Debargha

Comments

Sven W.

Is your APEX builder set to english or german? I had some scenarios where that made a difference (it shouldn't thou).

Timo Annemüller

Hi,

the Builder is set to german.

I found something out yesterday:

When i create a form with the wizard the button labels are in english, whats wrong.

When i create a form with interactive report, alle the button labels are in german, what they should be.

Maybe it a problem direct in Apex?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2017
Added on Oct 5 2017
#oracle-call-interface-oci
0 comments
1,257 views