Neoview Guide to Stored Procedures in Java (R2.3, R2.4)
Calling the Procedure: SUPPLYNUMBERS
To invoke the SUPPLYNUMBERS procedure in NCI:
SQL>call invent.supplynumbers(?,?,?);
The SUPPLYNUMBERS procedure returns this output in NCI:
AVRG MINM MAXM
----------- ----------- -----------
167 0 1132
--- SQL operation complete.
The average number of items in inventory is 167, the minimum number is 0, and the maximum
number is 1132.
Procedures in the INVENT Schema 105