Remote Stored Procedure

To set up a remote stored procedure, follow the same process as for standard stored procedures, with these key differences:

Only the parameters are important. You must define them in the same order as they appear in the stored procedure on the remote system.
The system doesn't define the stored procedure in the local database because it's marked as a remote procedure.
In the Developer, assign the remote database to the database property of the stored procedure component.

Database stored procedure options dialog with remote database settings

In the stored procedure form, select the Remote database option.
Enter the parameters for the stored procedure. If you have multiple parameters, define them in the same order as they appear in the remote procedure.
Save the stored procedure and check it in.
Define numeric values with decimals as NUMBER in your procedures and functions.
In your code logic, you can now define:

BEGIN_DEFINITIONS
VAR
    SP_TRACKING_DELETE : storedproc(SP_TRACKING_DELETE)
END_DEFINITIONS

ROUTINE PROCESS_MAIN
BEGIN_ROUTINE
    SP_TRACKING_DELETE.database := 'remotedbs'
    SP_TRACKING_DELETE.execute()
    if resok
        sme(SP_TRACKING_DELETE.X)
    else
        sme(getlastresult)
    endif
END_ROUTINE

Remote Stored Procedure

Contents