Importing Stored Procedures¶
To create a new stored procedure, click Stored procedure on the menu File > New.
You have to provide the following settings:
Name. Name of the new stored procedure. In our example,
Class name. Full name of the Java class that implements the stored procedure.
If the class you want to use is located in a Jar that was loaded into the Server from the File > Extension management dialog (see section Importing Extensions), select the Select jars check box and then, select the class name from the list.
In our example, select “Select Jars”, select
denodo-demo-storedproceduresand select the class name
Class path. Optional. Path to the jar file(s) that contain the class that implements the stored procedure.
Although you can use this field, we recommend importing the jar files into the Virtual DataPort server and then, select them in the Select Jars box. That way, you do not depend on these jars being on a particular location.
Leave this field empty if:
- You imported the jar file with the “Extension management” dialog.
- Or the jar file has been copied to the directory
To enter the path, click Browse to select the jar. To select more than one jar, hold Ctrl and select each jar.
When clicking Browse, you will browse the file system of the host where the Server is running and not where the Administration Tool is running.
Select Jars. If selected, select the Jar that contains the class you want to use.
To select two or more Jars, hold the Ctrl key and click on the required Jars.
In the Metadata tab, you can define the folder where the stored procedure will be stored and enter its description.
Click Save () to create the base view. The Tool will display a dialog with the properties of the new stored procedure and its input and output parameters (see Properties of a Stored Procedure).
The parameters of a stored procedure can be of types
IN parameters are the required input parameters to
execute the procedure; the
OUT parameters are the ones returned by
the execution of the procedure; and the
IN_OUT parameters are input
parameters that are also returned by the procedure.
The “Nullable” column indicates that the value of that parameter can be
The figure below shows information about the new
stored procedure: It has an input parameter (
taxid_list, of type
array, and an output parameter
avgrevenue(OUT), of type