[ QUOTE ]
We do call a Oracle stored procedures
One way is using B34A1030 (Execute external program)
We build up the string to call the procedure, and pass this into the bsfn and execute using an op$login:
eg: echo "EXECUTE proddta.procedure('<parameter1>', '<parameter2')"|sqlplus-s/@proddta
JDE 8.10, 8.97.1.2, Oracle 10.2, Unix
[/ QUOTE ]
Hey guys, I know this topic is old and has probably been regurgitated many times over, but I need some help with this.
I have a MSSQL 2000 server that is collecting production metrics, i.e. a custom application OUTSIDE of JDE is monitoring the production floor, collecting data into non-JDE tables, and displaying the data to the production floor.
I have a requirement where I need to use some of this data in JDE. My JDE data server is on a different server (MSSQL 2005) and I have a stored procedure that will populate the tables correctly and it sits on a scheduler on the MSSQL 2K server. In an application, I need to allow the user to repopulate the data manually if necessary (re-run the Stored Procedure). What I do not understand how to do is write the interface of the business function to do this. Would creating a batch file on the SQL 2K server and then calling it from the JDE App be the best route to go? Or call the SQL SP directly? Since this business function will run on the ENTERPRISE server, how do I configure the system to run the SQL 2K command line? I know I am missing something basic but can't seem to figure this one out.
I need to pass in 3 parameters: branch, shift, and data (JULIAN DATE!)
The command should look like this:
c:\osql.exr /U xxx /P xxx /Q "EXECUTE server.db.dbo.shiftSummary branch, shift, date"
OR should it be like this:
\\server\c$\osql.exr /U xxx /P xxx /Q "EXECUTE server.db.dbo.shiftSummary branch, shift, date"
Any help is greatly appreciated.