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
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/~billjReceived on Thu Sep 11 1997 - 00:00:00 CEST