Add an Oracle Stored Procedure Import Definition

Since version 1.4.1044.1304 (December 2015) Moorgate has supported Oracle Stored Procedures and Packages in Transaction, Confirmation and Transaction Detail Import Definitions. Here's how to do it

• • Select Oracle Stored Procedure as the Database Type

  • Enter the procedure name in the following format [PackageName].[ProcedureName] and Click Get Parameters to return the parameters

  • Select one parameter as the KeyValue

• Any other parameters can only accept a text input

  • Any conversions to other data types will have to be handled inside the stored procedure

  • You need to include a field in your query that maps to the Key Parameter

    • If your key parameter is N_Date and the key value should be set from the Cycle Date column, add a field CycleDate as N_Date to the select query in the Procedure Body

  • The procedure needs to return all the required columns

An example of an Oracle Package to import the Internal Transaction records is attached