Oracle function syntax in Pro*C

From: Bill Jones <wjones14_at_csc.com>
Date: 1997/09/11
Message-ID: <01bcbed0$db151c00$e7f20b99_at_plunger.gdeb.com>#1/1


What's the syntax to use Oracle's ROUND function in a Pro*C insert? Would it be one of these?:

EXEC SQL INSERT INTO mytable (ID_No, Weight)   VALUES (:id_no:id_no_ind, round (:weight:weight_ind,2));

or

EXEC SQL INSERT INTO mytable (ID_No, Weight)   VALUES (:id_no INDICATOR id_no_ind, round (:weight,2) INDICATOR weight_ind);

or something else?

The WEIGHT column is defined as NUMBER (8,2) in mytable. The host variable weight is a float.

-- 
--
Bill Jones                      e-mail addresses:
Computer Sciences Corp.                 (work)  wjones14_at_csc.com
Norwich, Connecticut                    (play)  billj_at_mindport.net
(860) 437-5650               WWW:   http://www.mindport.net/~billj
Received on Thu Sep 11 1997 - 00:00:00 CEST

Original text of this message