When you login to the database, you can view accessible stored procedures.
A feature that registers a function written in Java in the database server with the loadjava command and adds a database function in order to use the given Java function.
Right-click [Stored procedure] in the navigation tree and then select [Create Function].
Only Java types compatible with the selected SQL type are displayed so that the user does not make a mistake with type mapping.
For details, see "Java Stored Function/Procedure" in the CUBRID online manual.
A feature that registers a procedure written in Java in the database server with the loadjava command and creates a database procedure in order to use the given Java procedure.
Right-click [Stored procedure] in the navigation tree and then select [Create Procedure].
Only Java types compatible with the selected SQL type are displayed so that the user does not make a mistake with type mapping.
For details, see "Java Stored Function/Procedure" in the CUBRID online manual.
The following is a statement created by using the Create Procedure wizard above.
CREATE PROCEDURE "test_proc"("a" CHAR,"b" CHAR)
AS LANGUAGE JAVA
NAME 'FindPerson.FindProc(java.lang.String,java.lang.Integer)'
Right-click a certain function or a procedure and then select [Drop Function] or [Drop Procedure].
Right-click a certain function or a procedure and then select [Edit Function] or [Edit Procedure]. The feature works the same as with Create Function/Procedure.