XSU (XML utility) and value larger than specified precision allows for this column

   Hi:

      I'm using XSU12 (XML Utility) with Oracle8i, on a W2K server. When I try to save data into a field that contains a number (NUMBER(10, 0)), I get ORA-01438: value larger than specified precision allows for this column. However, if I do it with an INSERT sentence from SQL-Plus, it works perfectly.

        str += "<?xml version = '1.0'?>";
        str += "<ROWSET>";
        str += "<ROW num=\"1\">";
        str += "<ID>" + jtxtBudget.getText() + "</ID>";
        str += "<TITLE>" + jtxtTitle.getText() + "</TITLE>";
        str += "<QTY>" + jtxtQty.getText() + "</TITLE>";


        ..... .....

        ..... .....

        str += "</ROW>";
        str += "</ROWSET>";

            /* Oracle XSU package */
            OracleXMLSave sav = new OracleXMLSave(conn, "BUDGET");
            sav.insertXML(str);
            sav.close();

   What am I doing wrong. Any ideas?

   Thanks a lot in advance.
   Best wishes, Javier. Received on Mon Jul 22 2002 - 08:03:29 CDT