We presently have a need to run an Oracle Stored Procedure, and we would like to create a batch process that would run on our batch node during the off-peak hours. How would I go about invoking a stored procedure from a sub-classed SysBatchJob.
I played with the NexJ supplied “sql-execute” function, but that appears to be limited to “prepared statements”. I need to invoke an “execute immediate” command to run the stored procedure.
i.e. EXECUTE IMMEDIATE ‘CALL NEXJSVDB.LoadTier(”All”, 1000)’;
Or, is there a way to invoke a command that will run a PL/SQL block?
3 EXECUTE IMMEDIATE ‘CALL NEXJSVDB.LoadTier(”All”, 1000)’;
I also noticed that the documentation for “sql-execute” states: (For internal use only. Will be deprecated in the near future.)
If this is being deprecated, what will replace the ability to run sql against data that is not in the Model?