Calling Oracle Stored procedure/package from JDEdwards menu

Hi JDEList

We have written Oracle Stored procedure/package. What is the best way that it can be attached as an option in the menu. One of the way is to write the Windows NT Bacth file and then call it from menu as external call.. just wondering is there any other way to achive the same objective.

Here's what we do and why:

We create batch files to call SQL scripts. We then write a UBE to call the
batch file. The name of the batch file can be modified via a processing
option but only by Sys Admins.

In the UBE we use the B34A1030 BSFN (Execute External Program) to run the
batch file. The path and name of the batch file are passed in from a
processing option.

The main reason we did it this way is that we run UBE1 that calls UBE2, UBE3
and UBE4. UBE1 is the driver, UBE2 & UBE4 are normal JDE UBEs but UBE3 runs
an Oracle stored procedure. We wanted UBE4 to run right after UBE3 so a menu
choice wasn't feasible, neither was an AT job.

It's a bit more work than just putting a menu option to call a batch file
but was the only solution we came up with (I'm sure there are better
solutions).


Colin

B733.2 SP17.1_I1
Intel/NT/Oracle 8.1.7.1
FAT & WTS