User's Manual

Virtuoso 4.5 Application and Integration Reviewers Guide

Figure 5 – Linking and Qualifying the Stored Procedures

Figure 6 – External Data Sources

Note 1 - When linking in these procedures, for each remote procedure you have the option to

change how they will be referenced within Virtuoso. These include changing the fields for Local

Name, Database, and Schema.

Step 6. As shown in Figure 6 – External Data Sources above, for each procedure

there are radio buttons for selecting the PL Wrapper Requirements. This

option is of particular importance for remote procedures capable of returning

a result set. Remote procedures can be linked using a Virtuoso PL wrapper

meaning that Virtuoso procedure language code provides a mechanism for

negotiating the result set. The available options are:

• Soap Execution - Generates a PL wrapper that can be published to Web

Services.

• SQL Execution - Generates a PL Wrapper that is more suitable for

general SQL use.

• None - Does not generate and PL Wrapper code and simply links the

procedure by reference.

3.3.1.2 Publishing SQL Stored Procedures as Web Services

Before any procedures native or linked in exposed as SOAP Web Service a location in

HTTP space must be defined. As mentioned in the previous section, the