OraFAQ Forum: SQL & PL/SQL » not urgnet at all - ORA-01455: converting column overflows integer datatype

Home » SQL & PL/SQL » SQL & PL/SQL » not urgnet at all - ORA-01455: converting column overflows integer datatype

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

not urgnet at all - ORA-01455: converting column overflows integer datatype [message #239739]

Wed, 23 May 2007 04:06

fassi_79
Messages: 9
Registered: July 2006

Junior Member

i am trying to query a remort database through TOAD. erro accured

ORA-01455: converting column overflows integer datatype

[Updated on: Wed, 23 May 2007 08:21] by Moderator

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239742 is a reply to message #239739]

Wed, 23 May 2007 04:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your query?
What happens with SQL*Plus?
What is your versions (Oracle server, Oracle client, TOAD)?
Are you sure your TOAD is compatible with your Oracle version?

Regards
Michel

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239751 is a reply to message #239742]

Wed, 23 May 2007 04:20

fassi_79
Messages: 9
Registered: July 2006

Junior Member

server based oracle 9i and client is also 9i. Toad's version is Toad 7.60.11. My other computer are connectd with same configration.

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239753 is a reply to message #239751]

Wed, 23 May 2007 04:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And they can execute the query you didn't post?

Regards
Michel

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239755 is a reply to message #239753]

Wed, 23 May 2007 04:26

fassi_79
Messages: 9
Registered: July 2006

Junior Member

dear same query.

e.g. select * from tabl_name@ora9.us.oracle.com

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239761 is a reply to message #239739]

Wed, 23 May 2007 04:33

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

You still havent answered Michel question ?

Quote:

What happens with SQL*Plus?

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239766 is a reply to message #239761]

Wed, 23 May 2007 04:47

fassi_79
Messages: 9
Registered: July 2006

Junior Member

sql plus is working well. and same problem with PL/SQL Developer.

[Updated on: Wed, 23 May 2007 04:50]

Report message to a moderator

Re: urgnet ORA-01455: converting column overflows integer datatype [message #239780 is a reply to message #239766]

Wed, 23 May 2007 05:06

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So it is a problem with TOAD.
Ask them.

Regards
Michel

Report message to a moderator

Previous Topic:	Connect by Prior
Next Topic:	Differences

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 17:36:30 CST 2024