Fetching a Schema Object for Custom RPC Service

You must fetch a stored procedure, function, or package when you create custom RPC Service. However, you do not have to fetch a schema object for Request-Reply RPC Service and standard RPC Service.

In the Create Service Wizard wizard, after you select Request-Response from the Service Type list and click Next, the Schema Type window opens.

Procedure

  1. In the Schema Type window, click the browse button to open the ADB Business Object Schema Picker window.
  2. Click the Remote Business Object tab and expand the destination with the adapter configuration name.
    Use the Remote Business Object tab when a schema object that you want to fetch does not exist in the local repository, and use the Local Business Object tab when a schema object that you want to fetch exists in the local repository.
  3. Right-click procedure and click Fetch Procedure.

  4. In the Store Procedure Download Dialog window, specify a name for the call operation and select a stored procedure, function, or package from the schema object list. Then click OK.

    You can also specify the options in the Procedure Schema Information panel. For details, see Procedure Schema Information Reference.

    Note: TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) retrieves the signature of each stored procedure or function from the database. If you change the stored procedure or database connection while editing your project, you must return to the Store Procedure Download Dialog window and click Refresh to retrieve the changes from the database.
  5. Back in the ADB Business Object Schema Picker window, click the fetched object and click OK.

    The fetched object is displayed in the Schema field.