[HelpMe] Is there a problem in using PreparedStatement of JDBC with ORACLE ?

Hi,

i have a problem in using PreparedStatement of JDBC with ORACLE.

Very Simple example would not work correctly: like the below.  

        PreparedStatement updateSales;
        updateSales = _con.prepareStatement(
                "UPDATE COFFEES SET SALES = ? WHERE COF_NAME = ?";
        updateSales.setInt(1, 999);
        updateSales.setString(2, "Colombian");
        updateSales.executeUpdate();

When executing the above code, No warnings and exceptions occur. However, the matching value was not modified. What's the problem ?

Is there any problem in preparedStatement with ORACLE ?

Please, would you send me a simple and working example with ORACLE ?

Thanks in advance.

hchmoon_at_seri.re.kr Received on Mon May 04 1998 - 01:57:50 CDT