Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'ORA-24340: cannot support more than 255 columns'

Re: 'ORA-24340: cannot support more than 255 columns'

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 10 Mar 1999 18:55:46 GMT
Message-ID: <36eec024.22127697@192.86.155.100>


A copy of this was sent to tom.verzele_at_mediagenix.com (Tom Verzele) (if that email address didn't require changing) On Wed, 10 Mar 1999 12:42:21 GMT, you wrote:

>Hi...
>
>There are 2 oracle servers here. One of them is Oracle 7.3 & the other
>one is Oracle 8.0.4 . Both of them are NT versions.
>When I do a query with 256 columns on the Oracle 8.0.4 server, I get
>the following error : 'ORA-24340: cannot support more than 255
>columns'.
>But when I do the same query on the Oracle 7.3 server , everything
>works fine ??
>Anyone ?
>

Are you using a V7 client to connect to the 8.0.4 instance? If so when a V7 client selected more than 255 columns from a V8 server using a join, it got OER(24340): This operation cannot support more than 255 columns

It was reported in 8.0.3 and fixed in 8.0.4.1. Call support and reference bug# 618076 if this matches your environment...

>
>Tom Verzele
>System Administrator
>Mediagenix
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Mar 10 1999 - 12:55:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US