Stored Procedure

When you login to the database, you can view accessible stored procedures.

Create Function

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.

Create Procedure

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)'

Drop Function/Procedure

Right-click a certain function or a procedure and then select [Drop Function] or [Drop Procedure].

Edit Function/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.