Importing a Stored Procedure¶
CREATE PROCEDURE adds a new stored procedure
to the Virtual DataPort Server.
CREATE [OR REPLACE] PROCEDURE <name:identifier> CLASSNAME <className:literal> [ CLASSPATH <classPath:literal> ] [ JARS <jar name:literal> [, <jar name:literal>]* ] [ FOLDER = <literal> ] [ DESCRIPTION = <literal> ]
CLASSNAME: name of the Java class that
implements the stored procedure. This class must be loaded into the
Server (see the section Importing Extensions of the Administration
CLASSPATH: list of paths to the jar files that contains the Java classes of the procedure.
Although you can use this parameter, we recommend importing the jar files into the Virtual DataPort server and then,
reference them from the
JARS clause. That way, you do not depend on these jars being on a particular location.
JARS: list of names of the jar files that have been uploaded to the Virtual DataPort server and that this procedure depends on.
The use of the
OR REPLACE modifier specifies that, if there is a
procedure with the name indicated, this must be replaced by the new
procedure. This will lead to the recalculation of the schemas and query
capabilities of the derived views using the procedure.
Once created, a stored procedure can be modified using the
ALTER PROCEDURE statement.
ALTER PROCEDURE <name:identifier> [ CLASSNAME <className:literal> ] [ CLASSPATH = <classPath:literal> [<classPath:literal> ]* ] [ JARS <jar name:literal> [, <jar name:literal>]* ]
The meaning of the
CLASSPATH clauses is the same
CREATE PROCEDURE statement.