Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i + WebDB Problem

Re: Oracle8i + WebDB Problem

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Thu, 22 Mar 2001 07:42:38 GMT
Message-ID: <3ab9ac7b.5139510@news.online.de>

Jürgen, you don't say which versions. And pleas supply th NLS_LANG settings etc.

The problem could be the german comma separator.

On Wed, 21 Mar 2001 20:45:09 +0100, Juergen Wolf <JuWo_at_N-Club.de> wrote:

>Hi,
>
> I have installed Oracle8i and Webdb running a single site. The database
>is set to German NLS settings. When accessing a simple table using an
>user generated form I have come across some strange error. Everytime I
>try to enter a number value with some decimal character or group
>separator using the form I get a "ORA-01722: invalid number" error. When
>entering the number using the 'E' coding e.g. 1001e-2 I get no error.
>The row inserts fine into the db but it can't be changed anymore using
>webdb. Everytime I try to change it, I get an "WWV-14612 This row was
>changed by somebody else." error. I have accessed the db using the same
>webdb account both times.
>Every hint is highly appreciated.
>
>Regards
> Juergen

EMail: knijff_at_bigfoot.com Received on Thu Mar 22 2001 - 01:42:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US