How do I export stored procedures to use with the OA adapter?
The following steps describe how to export procedures for the OA adapter. • Use iStudio and select Export from the File menu. The Export Stored Procedures dialog is displayed. • Select the root of the list to select all stored procedures from all applications. Two files are created for each application and business object, if a base name is selected. The base name_application name_business object name.sql file defines all stored procedures for all messages from the selected business object and application. The base name_applicationname_business object nameTYPES.sql file defines all types used by the stored procedures in the first file. If you do not want to export all stored procedures, for all applications, as this can take a while, then select one or more applications. Only the stored procedures for those applications will be generated. You can also select messages based on the role. For example, if you select publish, then only publish messages will be generated. Or, you can select