Problems with a stored procedure , Oracle and JDBC

From: Andrea Bruschina <brucext_at_tin.it>
Date: Thu, 31 May 2001 17:58:33 GMT
Message-ID: <dDvR6.6394$vt.92765@news1.tin.it>

Problems with a stored procedure and JDBC

I have this problem:

I have a stored procedure (written in PL/SQL) that do something like this
(on a Oracle server 8i):

....
  First := 5 + 5;
  Second := 3

• Result is (NUMBER 6,3) Result := First*100/Second;

  ...

  q:= DBMS_SQL.EXECUTE('INSERT INTO table(NUMERICVALUE63)' ||

                                   VALUES(' || Result || ')';

  ...

....

My problem is:

When i call the stored procedure with SQLNavigator or SQL PLUS the command that is executed is:

INSERT INTO table(NUMERICVALUE63) VALUES(33.333);

and this for me is good...

but when i call the stoder procedure via JDBC(thin driver) i obtain

INSERT INTO table(NUMERICVALUE63) VALUES(33,333);

which give me a too many values error from the DBServer
(it uses the comma like separator, not like decimal character)

What i have to configure/do to have the right effect?

I live in Italy where we write 100% = 100,000% , not 100.000%

My client computer is a Windows NT4.

Thank to the helpers!

Andrea B. Received on Thu May 31 2001 - 12:58:33 CDT