Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

Index
A
ADJUSTSALARY procedure
creating, 93
invoking, 94
adjustSalary() method
code for, 31, 93
description of, 93
example of, 21
Altering SPJs, 50
Application classes, accessible to an SPJ, 33
Arguments, CALL statement
input types
arithmetic expression, 65
concatenation operation, 65
dynamic parameter, 65
literal, 65
scalar subquery, 65
SQL function, 65
list, 64
output types
dynamic parameter, 65
named parameter, 65
unnamed parameter, 65
Array, output parameter, 27
B
Bignum, 26
C
CALL operator, 75
CALL statement
argument list, 64
argument types
arithmetic expression, 65
concatenation operation, 65
dynamic parameter, 65
literal, 65
scalar subquery, 65
SQL function, 65
description of, 64
execution plan, 73
restrictions, 63
transaction behavior, 63
Calling SPJs (see Invoking SPJs)
Character sets, 46
Client applications, calling SPJs, 20, 68, 69
Compilation, Java, 33
Compound statement, 63
Connection objects, 30
Connection pooling, 30
Create Procedure Wizard, 43
Creating SPJs
description of, 43
examples of, 77
privileges, 43
CUSTOMER table, 116
D
DAILYORDERS procedure
creating, 80
invoking, 81
Dangling reference, stored procedures, 39, 41
Data source URL, 30
Data types
conversion of parameter arguments, 64
Java, 26
SQL, 26
Database objects, referring to, 31
Database, sample, 109
DB Admin
creating SPJs, 43
deleting SPJ JAR files, 41
displaying SPJs in a schema, 47
downloading SPJ JAR files, 38
dropping SPJs, 49
granting privileges, 54
renaming SPJ JAR files, 39
required version, 23
revoking privileges, 57
showing privileges, 60
uploading SPJ JAR files, 35
Default connection, 30
DEPT table, 111
Displaying SPJs
using DB Admin, 47
using NCI, 49
Documents, related information, 16
Dropping SPJs, 49
E
EMPLOYEE table, 109
EMPLOYEEJOB procedure
creating, 95
invoking, 95
employeeJob() method
code for, 95
description of, 95
Error messages, finding, 73
Exceptions, handling, 32
EXECUTE privilege, 51
Execution plan, CALL statement, 73
EXPLAIN function, 75
EXPLAIN statement, 74
G
GRANT EXECUTE statement, 51
GRANT statement, 51
Grant/Revoke Privileges Tool, 55
I
IN parameters, 65
127