Re: ORA-01401 problem with similar tables

From: <mpir_at_compuserve.com>
Date: Tue, 22 Jun 1999 20:12:10 GMT
Message-ID: <7koqmf$itc$1@nnrp1.deja.com>

How long is the field in the asp/form and how is it defined? If it is padding length with spaces you might go beyond the 30.

In article <7ko7ef$43o$1_at_zonnetje.NL.net>, "erol yavuz" <erol_at_context.nl> wrote:
> Hi there,
>
> I'm still somewhat of a rookie when it comes to building Oracle
databases,
> but I have a (for me) disturbing problem when I fill a table in an
Oracle
> database via ASP-webforms.
>
> The strange thing is that when I add an additional field to one table
and
> try to fill it with
> a fixed length variable ( let's say I try to fill the column with the
text
> "hello") the error appears:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Oracle][ODBC][Ora]ORA-01401
>
> and is thus not put into the table.
> I've chosen to define the field as varchar2(30) and so, it should not
give
> any problems when I try to enter "hello" into it.
>
> If, on the other hand, I do the same procedure with a different
table, it
> gives no such error message!!!
>
> I've have looked at the structure of both tables in the Schema
manager but
> have found no differences between them.
>
> Does anybody know what causes this problem?
>
> PS. Heeeeeeeelllp!
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 15:12:10 CDT