Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

Calling the Procedure: TOPSALESREPS
To invoke the TOPSALESREPS procedure in NCI:
SQL>call persnl.topsalesreps(1);
The TOPSALESREPS procedure returns this information about the top five sales representatives
during the first fiscal quarter:
EMPNUM FIRST_NAME LAST_NAME TOTAL
------ --------------- -------------------- --------------------
227 XAVIER SEDLEMEYER 172460.00
231 HERB ALBERT 67025.00
222 MARTIN SCHAEFFER 52000.00
226 HEIDI WEIGL 28985.00
220 JOHN HUGHES 22625.00
--- 5 row(s) selected.
--- SQL operation complete.
Procedures in the PERSNL Schema 99