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!

Which is the best way to process batch database query between OTL_STREAM with c and SQL_PLUS comma

olekhanchaiJun 18 2015 — edited Jun 19 2015

I'm using linux to process batch database using otl_stream. I would like to know how different between

OTL_STREAM with c++ to create execute program and SQL_PLUS with shell script which is the best way to process batch database query?

which process best performance and fastest way to process?

Comments

Timo Hahn

Arun, tell us your jdev version, please!

I guess it will only work for full pages, meaning the alert has to be defined the jsf page.

You can compare the html which is generated from the jsf page the fragment. You may spot a difference which you can then eliminate by e.g. putting the applet into a panelformlayout.

Timo

Arun T

Hi Timo, thanks for your reply.

We are using 12.1.3 JDev and as a workaround i am calling the jsf button from an jsff button. From the jsf button the applet is created in bean dynamically, not in the page. It works fine

I will compare the source generated and get back on this.

Thanks

- Arun

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

Post Details

Locked on Jul 16 2015
Added on Jun 18 2015
#oracle-call-interface-oci
0 comments
457 views