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

• First SQL parameter:
— Name: partnum
— Direction: IN
— SQL Data Type: INTEGER
— Java Data Type: int
Parameters:
• Second SQL parameter:
— Name: partdesc
— Direction: OUT
— SQL Data Type: CHARACTER
◦ Length: 18
◦ Varying: not selected
◦ Upshift: not selected
◦ Character set: ISO88591
— Java Data Type: java.lang.String[]
• Third SQL parameter:
— Name: price
— Direction: OUT
— SQL Data Type: NUMERIC
◦ Precision: 8
◦ Scale: 2
— Java Data Type: java.math.BigDecimal[]
• Fourth SQL parameter:
— Name: qty_available
— Direction: OUT
— SQL Data Type: INTEGER
— Java Data Type: int[]
• Dynamic result sets: 4
• Accesses Database: selected
Attributes:
Calling the Procedure: PARTDATA
To invoke the PARTDATA procedure in NCI:
SQL>call sales.partdata(212,?,?,?);
The PARTDATA procedure returns this information about part 212:
PARTDESC PRICE QTY_AVAILABLE
------------------ ---------- -------------
PC SILVER, 20 MB 2500.00 3525
ORDERNUM ORDER_DATE DELIV_DATE SALESREP CUSTNUM QTY_ORDERED
-------- ---------- ---------- -------- ------- --------------------
400410 2003-03-27 2003-09-01 227 7654 12
500450 2003-04-20 2003-09-15 220 324 8
--- 2 row(s) selected.
LOC_CODE PARTNUM QTY_ON_HAND
-------- ------- -----------
G87 212 20
A87 212 18
--- 2 row(s) selected.
PARTNUM SUPPNUM PARTCOST QTY_RECEIVED
------- ------- ---------- ------------
212 3 1900.00 35
212 1 2000.00 20
Procedures in the SALES Schema 79