Modify Stored Procedure Definitions

Before you can define a method that calls a database stored procedure, you must describe it to Data Access Builder. To view the list of stored procedures that have been defined within Data Access Builder, open the Stored Procedures List window by doing one of the following procedures:

If the stored procedure you want to work with is not listed in the Imported Stored Procedures List in the Stored Procedures List window, then you must add the definition to Data Access Builder (see the section Define Stored Procedures).

Stored procedures definitions that were previously imported or created can be modified to correct errors or to reflect changes made to the stored procedure on the database. To modify a stored procedure definition, select the definition from the Imported Stored Procedures List and click Modify.

Warning! Once a stored procedure has been defined to Data Access Builder, any modification to its definition deletes all stored procedure call methods mapped to it.

In the Modify Stored Procedure window, adjust the following fields as needed. Ensure they accurately reflect the database stored procedure's definition.

  1. Stored Procedure field - Enter a name for the stored procedure definition.
  2. Parameters list box - Each parameter is listed in the list box. To work with one of them, select it and do any of the following actions on it.
    1. Delete - Deletes the selected parameter.
    2. Copy - Copies the selected parameter and generates a new, unique name for the new parameter.
    3. Move Up - Moves the selected parameter up in the order of parameters. Parameters must appear in the same order as they do in the stored procedure on the database.
    4. Move Down - Moves the selected parameter down in the order of parameters. Parameters must appear in the same order as they do in the stored procedure on the database.
    5. Modify - Change the Parameter Type, SQL Name, SQL Type, Length, Precision, or Scale, and click Modify. See the next list item, below, for details about each of these fields.
  3. To add a new parameter, ensure you have finished modifying the currently-selected parameter, and then do the following steps:
    1. Select a Parameter Type, according to what the parameter does within the stored procedure:
      • In - Designates an input parameter to the stored procedure.
      • Out - Designates an output parameter to the stored procedure.
      • In/Out - Designates a parameter that is used for both input an output.
      • Result Column - Designates a column in the result set returned by the stored procedure.
      • Return Value - Designates the return value for the stored procedure.
    2. Select an SQL Name and Type; as appropriate, enter the Length, Precision, and Scale of the SQL parameter.
    3. Click Add.
    4. Adjust its position in the parameter list by using the Move Up and Move Down buttons. Parameters must appear in the same order as they do in the stored procedure on the database.

When you are finished modifying the definition, click OK to exit the dialog, or Cancel to cancel your changes and exit.



User-Defined Methods


Define Stored Procedures
Display List of Defined Stored Procedures
Add User-Defined Methods That Are Stored Procedure Calls


Sample: Create and Use a Stored Procedure Call on a Persistent Object