Neoview Guide to Stored Procedures in Java (R2.5)

Use the Create Procedure Dialog Box

This table shows reference information for the Create Procedure dialog box:

ActionControl or FieldGroup Box

Enter a name for the new procedure. The name must be unique and must

not exist for any procedure, table, or view in the same schema. The procedure

name is not case-sensitive. Neoview SQL automatically qualifies the

procedure name with the name of the schema in which you are creating the

procedure. For example, if you enter monthlyorders as the procedure name,

Neoview SQL stores the procedure as schema-name.MONTHLYORDERS.

NameName

Click [ Browse ] to navigate to a .jar file.

NOTE: Only .jar files that you have uploaded or .jar files that have been

uploaded by members of the Neoview role to which you belong are visible

to you.

Code FileCode

Select a class.Class Name

When you select a class, the method names and parameter types for that

class appear in the right pane.

NOTE: Only methods that can be used in a procedure are visible. For

details, see “Use a Method in a Procedure” (page 39).

Method Name

Is the name for this Neoview SQL parameter.NameParameters

• IN — passes data to a procedure

• INOUT — passes data to and accepts data from a procedure. The

parameter must be an array.

• OUT — accepts data from a procedure. The parameter must be an array.

Direction

Displays the Neoview SQL data type that is the best match for the Java

signature in the Java Data Type column.

SQL Data Type

Displays the signature for the Java method that you selected.Java Data Type

Click to edit the selected parameter.[ Edit ]

Controls the maximum number of result sets the procedure can return. This

control is enabled only if the method signature contains a java.sql.ResultSet[]

object. If the method contains a result set object, the valid range is 1 to 255.

This value is automatically set to zero if the selected Java method does not

have a java.sql.ResultSet[] object.

Number of dynamic

result sets

Attributes

If selected, the procedure performs SQL operations. If cleared, the procedure

does not perform SQL operations.

NOTE: Neoview SQL returns an error if this attribute is cleared and the

procedure performs SQL operations.

Accesses Database