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:
- Select Stored Procedures from
the popup menu of the desired database; or,
- In the Add Stored Procedure Call window,
the Procedure Name drop-down box lists
all those defined. Click the Show Procedures
button to open the Stored Procedures List window.
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.
- Stored Procedure field -
Enter a name for the stored procedure definition.
- 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.
- Delete - Deletes
the selected parameter.
- Copy - Copies the
selected parameter and generates a new, unique
name for the new parameter.
- 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.
- 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.
- 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.
- To add a new parameter, ensure you have
finished modifying the currently-selected parameter, and
then do the following steps:
- 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.
- Select an SQL Name and
Type; as appropriate, enter the Length,
Precision, and Scale of
the SQL parameter.
- Click Add.
- 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