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

NOTE: There can be more than one java.sql.ResultSet[] parameter, but they must all be at
the end of the method signature.
• Have these parameter types:
Type
Parameter Type
or Class
“java.lang.String”character
“java.lang.String[]”
“java.lang.Integer”numeric
“java.lang.Integer[]”
“java.lang.Long”
“java.lang.Long[]”
“java.lang.Float”
“java.lang.Float[]”
“java.lang.Double”
“java.lang.Double[]”
“java.math.BigDecimal”
“java.math.BigDecimal[]”
“java.sql.Date”date/timestamp
“java.sql.Date[]”
“java.sql.Time”
“java.sql.Time[]”
“java.sql.Timestamp”
“java.sql.Timestamp[]”
“short”primitive
“short[]”
“int”
“int[]”
“long”
“long[]”
“float”
“float[]”
“double”
“double[]”
“java.sql.ResultSet[]”result sets
Drop a Procedure
To drop a procedure, you must own the procedure, have SUPER.SUPER privileges, or have the
necessary DDL privileges to drop the procedure. The schema owner can grant such privileges
to other users or roles. For example, if the schema owner granted your role privileges to drop
40 Creating SPJs in the Neoview Database