Neoview Guide to Stored Procedures in Java (R2.2)
Calling the Procedure: SUPPLYNUMBERS
To invoke the SUPPLYNUMBERS procedure in Neoview Script:
SQL>call invent.supplynumbers(?,?,?);
The SUPPLYNUMBERS procedure returns this output in Neoview Script:
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 103