Re: Error Ora-1722: Invalid Number !!!!

Hi,

I had a case like that.

In my case, I was using Powerbuilder 6.0 and while I used a decimal bind variable to interact with oracle I received that error; changing the datatype to long it worked right. But there is no reason for that, as long both are valid numeric datatypes, and should be compatible. I seems to me that there is something to do with SQL*Net or its installation, because in some machines the program worked well with both datatypes.

Sorry this is not any solution.

Luis Cabral

Mauff01 wrote:
>
> Since 15 days , We found everywhere this nice message.
> Could anyone tell us if it found this message too and when ?
>
> It seems that this error occurs when a bad numeric format is used , but it
> occurs also when we don't use numbers or date datatypes.
>
>
Received on Tue Aug 11 1998 - 05:46:16 CDT