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

Calling the Procedure: MONTHLYORDERS
To invoke the MONTHLYORDERS procedure in NCI:
SQL>call sales.monthlyorders(3,?);
The MONTHLYORDERS procedure determines the total number of orders during a specified
month and returns this output in NCI:
ORDERNUM
-----------
4
--- SQL operation complete.
In March, there were four orders.
74 Sample SPJs