Home » RDBMS Server » Server Administration » Help with Query !!!!
Help with Query !!!! [message #374457] Wed, 13 June 2001 08:31 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hi,

Can somebody please help me with the insert statement problem.

I'm doing an insert into a x table selecting from another y table and it returns with an error:

ORA-01401: inserted value too large for column

I tried to verify and map the datatypes of both the tables, but I'm not able to figure out as to for which column it is complaining about.

Is there any way where I could detect this.

Please help me with this problem for its very urgent !!

Thanks in advance.
Arpit.

Report message to a moderator

Re: Help with Query !!!! [message #374458 is a reply to message #374457] Wed, 13 June 2001 09:28 Go to previous messageGo to next message
Prasad
Messages: 104
Registered: October 2000
Senior Member
The value u are passing to first table coloumn is bigger than the length of ur first table field.so check for it.

Report message to a moderator

Re: Help with Query !!!! [message #374459 is a reply to message #374457] Wed, 13 June 2001 09:32 Go to previous messageGo to next message
Prasad
Messages: 104
Registered: October 2000
Senior Member
The value u are passing to first table coloumn from select statement is bigger than the length of ur first table field.so check for it.

Report message to a moderator

Re: Help with Query !!!! [message #374475 is a reply to message #374457] Thu, 14 June 2001 01:52 Go to previous message
Bui Viet Hung
Messages: 1
Registered: June 2001
Junior Member
The problem may be in character set you're using for your database. I don't know what is character set in your database?

Report message to a moderator

Previous Topic: sql on desk top at home, personal edition
Next Topic: un manual de pl-sql oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 15:52:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.