Salesforce

Generated Stored Procedures Component (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
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
Attachment 
Attachment