LucidDbCreateProcedure

Syntax

CREATE PROCEDURE qualified-procedure-name ( [ procedure-param-def, ... ] )
LANGUAGE JAVA
[ PARAMETER STYLE JAVA ]
[ SPECIFIC specific-name ]
[ NO SQL | CONTAINS SQL | READS SQL DATA | MODIFIES SQL DATA ]
EXTERNAL NAME 'external-name'
[ EXTERNAL SECURITY { DEFINER | INVOKER | IMPLEMENTATION DEFINED } ]

procedure-param-def ::= [IN] param-name data-type

See LucidDbDataTypes for specification of data-type.

See LucidDbCreateJavaUdf for specification of external-name.

Example

CREATE PROCEDURE set_java_property(in name varchar(128),val varchar(128))
LANGUAGE JAVA
NO SQL
EXTERNAL NAME 'class net.sf.farrago.test.FarragoTestUDR.setSystemProperty';