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

Calling the Procedure: PARTLOCS
To invoke the PARTLOCS procedure in NCI:
SQL>call invent.partlocs(212, 18);
The PARTLOCS procedure accepts the part number 212 and returns a set of locations that have
18 of those parts and a set of locations that have more than 18 of those parts:
LOC_CODE PARTNUM QTY_ON_HAND
-------- ------- -----------
A87 212 18
--- 1 row(s) selected.
LOC_CODE PARTNUM QTY_ON_HAND
-------- ------- -----------
G87 212 20
--- 1 row(s) selected.
--- SQL operation complete.
100 Sample SPJs