Neoview Guide to Stored Procedures in Java (R2.2)
Calling the Procedure: SUPPLIERINFO
To invoke the SUPPLIERINFO procedure in Neoview Script:
SQL>call invent.supplierinfo(25,?,?,?,?,?);
The SUPPLIERINFO procedure accepts the supplier number 25 and returns this output in
Neoview Script:
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 101