Search This Blog

Friday, July 31, 2015

SQL Developer "Cannot find Java.." Issue

Even in version 4.1 SQL Developer is not fixed to include jdk along with it's installation. It still asks for java path for the first time and it very pain to overcome this.

1. First install JDK not JRE. Notedown the installation path.
2. Run SQL Developer as Admin
3. Enter the jdk path upto bin. make sure you have \ at the end and don't include bin
C:\Program Files\Java\jdk1.8.0_51\

Wednesday, March 4, 2015

Submit a concurret program from Oracle workflow

Workflow delivers 2 options for running concurrent requests:

Option 1 - Submit Concurrent Program Activity - Submits the request only. Does not wait for completion. *The attached example
Option 2 - Execute Concurrent Program Activity - Submits the request and waits for the completion. *Requires background engine.

Check out the workflow developer's guide for more info on these. They are under the "Concurrent Manager Standard Activities" section.

Accessing the Concurrent Manager Standard Activities
-----------------------------------------------------------------------------------
To access these activities in your own workflows, you need to use the workflow builder to connect to your 11i instance (as apps). Then you can select the "Concurrent Manager Functions" item type. Open this and drag the required function into your own workflow. There is an additional function called "Wait for Concurrent Program Activity". Check out the wf dev guide for more on this one