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

• First SQL parameter:
— Name: empnum
— Direction: IN
— SQL Data Type: NUMERIC
◦ Precision: 4
◦ Scale: 0
— Java Data Type: java.math.BigDecimal
• Second SQL parameter:
— Name: percent
— Direction: IN
— SQL Data Type: FLOAT
◦ Bits of precision: 52
— Java Data Type: double
• Third SQL parameter:
— Name: newsalary
— Direction: OUT
— SQL Data Type: NUMERIC
◦ Precision: 8
◦ Scale: 2
— Java Data Type: java.math.BigDecimal[]
Parameters:
• Dynamic result sets: 0
• Accesses Database: selected
Attributes:
Calling the Procedure: ADJUSTSALARY
To invoke the ADJUSTSALARY procedure in NCI:
SQL>call persnl.adjustsalary(29, 2.5, ?);
The ADJUSTSALARY procedure updates the salary of employee number 29 by 2.5 percent and
returns this output in NCI:
NEWSALARY
----------
139400.00
--- SQL operation complete.
The salary of employee number 29 was originally $136,000.00 and became $139,400.00 after the
invocation of ADJUSTSALARY.
86 Sample SPJs