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

Calling the Procedure: SUPPLIERINFO
To invoke the SUPPLIERINFO procedure in NCI:
SQL>call invent.supplierinfo(25,?,?,?,?,?);
The SUPPLIERINFO procedure accepts the supplier number 25 and returns this output in NCI:
SUPPNAME ADDRESS CITY STATE ZIPCODE
------------------ ---------------------- -------------- ------------ ----------
Schroeder's Ltd 212 Strasse Blvd West Hamburg Rhode Island 22222
--- SQL operation complete.
Supplier number 25 is Schroeder’s Ltd. and is located in Hamburg, Rhode Island.
Procedures in the INVENT Schema 103