Re: ORA-01722:invalid number

Ok first of all, let me calrify you are using a single quote in float and you are getting error, as far as I know you should get error using a single quote ( ') in float numbers in Sql statements.

you should not use quotes in number data types.

"Antonio Martinez" <anmartinez_at_itevelesa.com> wrote in message news:<3bc5dd1c$1_1_at_news.landsraad.net>...
> ORACLE-SOLARIS
>
> This is the cuestion:
>
> I've a software in java against ORACLE 7.3 with JDBC. It's run in web
> environment.
> Next week we'd changed oracle version to ORACLE 8.1 and this is the error
> when use ' (simple quote) with float numbers in sql sentences.
>
> With JDBC for ORACLE 7.3 and ORACLE 7.3 all is good but now with ORACLE 8.1
> and any drivers JDBC fails.
>
> How can i solve this question?
>
> Thanks for all.
Received on Thu Oct 11 2001 - 17:45:43 CDT