Neoview Guide to Stored Procedures in Java (R2.2)
Calling the Procedure: MONTHLYORDERS
To invoke the MONTHLYORDERS procedure in Neoview Script:
SQL>call sales.monthlyorders(3,?);
The MONTHLYORDERS procedure determines the total number of orders during a specified
month and returns this output in Neoview Script:
ORDERNUM
-----------
4
--- SQL operation complete.
In March, there were four orders.
Procedures in the SALES Schema 81