OraFAQ Forum: SQL & PL/SQL » ORA-01455 Converting column overflows integer datatype

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01455 Converting column overflows integer datatype

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

ORA-01455 Converting column overflows integer datatype [message #1539]

Fri, 10 May 2002 05:36

sorcer
Messages: 19
Registered: January 2002

Junior Member

Hello,
When i want to do a simple query :
SELECT TO_NUMBER(V_COL) FROM TABLE_1
I have this error ORA-01455. My column V_COL can contain '7895487954'.
I know i must define a larger datatype but i don't know how.
Please help me!

Report message to a moderator

Re: ORA-01455 Converting column overflows integer datatype [message #1540 is a reply to message #1539]

Fri, 10 May 2002 08:09

K. Balasubramanian
Messages: 10
Registered: April 2002

Junior Member

Hai,
Try altering datatype with long and execute query. It will work.

Bye

Regards,

K. Bala

Report message to a moderator

Re: ORA-01455 Converting column overflows integer datatype [message #1551 is a reply to message #1539]

Sat, 11 May 2002 02:21

sorcer
Messages: 19
Registered: January 2002

Junior Member

How can i alter the datatype?

Report message to a moderator

Re: ORA-01455 Converting column overflows integer datatype [message #1560 is a reply to message #1539]

Mon, 13 May 2002 03:40

K. Balasubramanian
Messages: 10
Registered: April 2002

Junior Member

Since alter cannot be done if the field is not empty so create a new field and transfer the existing data to that new field in number datatype and

alter VCOL colum to long as

alter table dummy modify (vcol long);

Try this .

Regards

K. Bala

Report message to a moderator

Re: ORA-01455 Converting column overflows integer datatype [message #1584 is a reply to message #1560]

Wed, 15 May 2002 00:16

sorcer
Messages: 19
Registered: January 2002

Junior Member

I don't want to alter any fields, i just want to convert a varchar2 column in a number column. Because i need a result in number datatype.

Report message to a moderator

Previous Topic:	PL/SQL function returning table OR parameterized view
Next Topic:	generate sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 13:21:45 CDT 2024