Skip to Main Content

Analytics Software

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!

Call .BAT From an Integration Script

user10678366Oct 2 2012 — edited Oct 2 2012
Hi All,

I have a batch file that is being called from an Integration Import Script. The batch file calls an external process (ODI Scenario).

When I execute the integration script from the WorkBench the Batch file is being executed just fine. However when I call the Integration Script via Import in the Web the Process just keep running and doesnt complete.

So, I undid the batch file call in the integration script just to make sure the rest of the script is good, and it works fine within the Web.

Any thoughts on why the batch process is not being executed within the web when called from within an integration script?

Heres the code for the batch called within the integration script;


'Call ODI

Set Shell = CreateObject("Wscript.Shell")
shell.run strODIBatchPath & "WEB_FOCUS_BATCH.BAT"
Set Shell = Nothing

To add to my misery the batch file is executed just fine when called from a Custom Web Script...

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2012
Added on Oct 2 2012
6 comments
605 views