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

136.77

--- SQL operation complete.

In a Neoview Script session, invoke the SPJ named TOTALPRICE again by preparing and

executing a CALL statement in which all three parameters accept values that are set by the USING

clause of the EXECUTE statement. The INOUT parameter returns the total price:

SQL>prepare stmt2 from call sales.totalprice(?,?,?);

--- SQL command prepared.

SQL>execute stmt2 using 3, 'economy', 16.99;

The output of the prepared CALL statement is:

*** WARNING[11217] Java execution: Data overflow occurred while retrieving data

at parameter position 3. Value is truncated.

PRICE

--------------------

57.12

--- SQL operation complete.

Returning Result Sets in Neoview Script

If a CALL statement returns result sets, Neoview Script displays column headings and data for

each returned result set in the same format as SELECT statements. For example, this CALL

statement returns the number of orders as an output parameter and two result sets in the Neoview

Script session:

SQL>call sales.ordersummary('01-01-2001', ?);

NUM_ORDERS

--------------------

ORDERNUM NUM_PARTS AMOUNT Order/Date Last Name

---------- -------------- --------------- ---------- ------------------

100210 4 19020.00 2003-04-10 HUGHES

100250 4 22625.00 2003-01-23 HUGHES

101220 4 45525.00 2003-07-21 SCHNABL

200300 3 52000.00 2003-02-06 SCHAEFFER

200320 4 9195.00 2003-02-17 KARAJAN

200490 2 1065.00 2003-03-19 WEIGL

--- 13 row(s) selected.

Order/Num Part/Num Unit/Price Qty/Ord Part Description

---------- -------- ------------ ---------- ------------------

100210 2001 1100.00 3 GRAPHIC PRINTER,M1

100210 2403 620.00 6 DAISY PRINTER,T2

100210 244 3500.00 3 PC GOLD, 30 MB

100210 5100 150.00 10 MONITOR BW, TYPE 1

100250 6500 95.00 10 DISK CONTROLLER

100250 6301 245.00 15 GRAPHIC CARD, HR

--- 70 row(s) selected.

Calling SPJs in Neoview Script 67