Salesforce

Generated Stored Procedures Component (Magic xpa 4.x)

Printable View
« Go Back

Information

 
Approval Process StatusPublished
Objective
Description

Generated Stored Procedures Component (Magic xpa 4.x)

When you have finished using the Stored Procedures wizard, the following will occur:

  • The resulting component will contain a public program for each stored procedure that was requested.

  • For each stored procedure parameter, a parameter is defined in the task data view with a corresponding model.

  • Each program uses the Direct SQL to access the stored procedure.

  • Parameters are added to the Direct SQL statement as Input arguments.

  • Return values are added as Output arguments.

  • To generate a Direct SQL statement, in/out parameter has to be sent by reference.

  • In Oracle, the Output variables are also created as parameters.

Reference
TitleGenerated Stored Procedures Component (Magic xpa 4.x)
URL NameGenerated-Stored-Procedures-Component-xpa-4x