Oracle Applications: Submitting Concurrent Request Using FND_CONCURRENT.WAIT_FOR_REQUEST Sample Code

Posted by Jiltin     Tags: , 15 May, 2009    9,019 views    (0) Comment

When submitting concurrent requests using PL/SQL, it is often desired to have the parent process wait until all the child processes have completed before completing itself. The following describes the function used to accomplish this. Refer Metalink 1021956.6: The following describes how to submit concurrent requests using PL/SQL and have the parent request ‘wait’ until each of the child processes have completed before it completes. Use the FND_CONCURRENT.WAIT_FOR_REQUEST Read Full Article (Click here)...

Categories : 11i Scripts, Oracle AOL Tags : ,

Toad explain plan script

Posted by Jiltin     Tags: , , , 14 May, 2008    3,566 views    (1) Comment

Can anybody send me the Toad explain plan (notoad.sql) script to me. My toad explain plan is not working.? Here you go: Download Toad explain plan script TOAD allows you to easily see the explain plan for the currently executed SQL statement. This is visualized on the Explain Plan tab in the results panel. TOAD does support changing the Optimizer Mode by right-clicking on the SQL statement and selecting the Optimizer Mode option. Cost-based hints can easily be added by using the SQL Templates Read Full Article (Click here)...

Categories : Scripts Oracle Tags : , , ,