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

Calling the Procedure: DAILYORDERS
To invoke the DAILYORDERS procedure in NCI:
SQL>call sales.dailyorders(date '2003-03-19', ?);
The DAILYORDERS procedure determines the total number of orders on a specified date and
returns this output in NCI:
NUMBER
-----------
2
--- SQL operation complete.
On March 19, 2003, there were two orders.
72 Sample SPJs