Home » SQL & PL/SQL » SQL & PL/SQL » not urgnet at all - ORA-01455: converting column overflows integer datatype
not urgnet at all - ORA-01455: converting column overflows integer datatype [message #239739] Wed, 23 May 2007 04:06 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: urgnet ORA-01455: converting column overflows integer datatype [message #239751 is a reply to message #239742] Wed, 23 May 2007 04:20 Go to previous messageGo to next message
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.
Re: urgnet ORA-01455: converting column overflows integer datatype [message #239753 is a reply to message #239751] Wed, 23 May 2007 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And they can execute the query you didn't post?

Regards
Michel
Re: urgnet ORA-01455: converting column overflows integer datatype [message #239755 is a reply to message #239753] Wed, 23 May 2007 04:26 Go to previous messageGo to next message
fassi_79
Messages: 9
Registered: July 2006
Junior Member
dear same query.


e.g. select * from tabl_name@ora9.us.oracle.com
Re: urgnet ORA-01455: converting column overflows integer datatype [message #239761 is a reply to message #239739] Wed, 23 May 2007 04:33 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You still havent answered Michel question ?
Quote:
What happens with SQL*Plus?
Re: urgnet ORA-01455: converting column overflows integer datatype [message #239766 is a reply to message #239761] Wed, 23 May 2007 04:47 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So it is a problem with TOAD.
Ask them.

Regards
Michel
Previous Topic: Connect by Prior
Next Topic: Differences
Goto Forum:
  


Current Time: Sun Dec 04 10:54:37 CST 2016

Total time taken to generate the page: 0.12322 seconds