Neoview Guide to Stored Procedures in Java (R2.5)
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.
98 Sample SPJs