OraFAQ Forum: SQL & PL/SQL » How to update a Long field in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » How to update a Long field in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to update a Long field in Oracle [message #185507]

Wed, 02 August 2006 01:37

hskramesh
Messages: 2
Registered: July 2006
Location: Chennai

Junior Member

Hi,

kindly tell me the solution to update a Long field

Regards
RAMESH KUMAR.K

Report message to a moderator

Re: How to update a Long field in Oracle [message #185523 is a reply to message #185507]

Wed, 02 August 2006 02:35

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

What problem are you having with using the UPDATE statement?

If you tell us what you are trying to do, show us what you've already tried, and let us know what the problem you hit was, we may be able to help.

Report message to a moderator

Re: How to update a Long field in Oracle [message #185556 is a reply to message #185523]

Wed, 02 August 2006 05:36

hskramesh
Messages: 2
Registered: July 2006
Location: Chennai

Junior Member

It shows the following error,

"can not inserted too many column"

Regards
Ramesh Kumar

Report message to a moderator

Re: How to update a Long field in Oracle [message #185557 is a reply to message #185556]

Wed, 02 August 2006 05:44

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

My awesome psychic abilities tell me that this isn't actually the error message that you're getting.
Is your actual error:

ORA-00913: too many values

ORA-01401: inserted value too large for column

or is it something else

Report message to a moderator

Previous Topic:	Sql query need to pivot table format
Next Topic:	suffix or prefix negative value of the column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:46:09 CST 2024