| Title: | DBSTARS Conference |
| Moderator: | BROKE::BASTINE |
| Created: | Wed Feb 02 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 791 |
| Total number of notes: | 1521 |
From: BROKE::GREEN 13-MAY-1997 11:00:46.73
To: GREEN,DIANE
CC: GREEN
Subj: SQL/Services only supports up to 500 columns
From: BROKE::BASTINE "please reply to rbastine@us.oracle.com" 13-MAY-1997 10:52:20.10
To: green
CC: BASTINE
Subj: Did you see this?
<<< NOMAHS::DISK$NOMAHS1:[NOTES$LIBRARY]SQL_SERVICES.NOTE;1 >>>
-< SQL/Services Forum >-
================================================================================
Note 2201.4 ACCVIO during large query 4 of 4
SQLSRV::MAVRIS "Sue Mavris - smavris@us.oracle.com" 5 lines 13-MAY-1997 09:35
-< limit of 500 columns >-
--------------------------------------------------------------------------------
This shouldn't cause an accvio, but SQL/Services can only handle 500 columns.
I'm not sure if this is documented anywhere... but it has always been the
case.
Sue
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 782.1 | Final - sent to Mem 5/21/97 | BROKE::BITHER | Wed May 21 1997 07:49 | 38 | |
From: BROKE::BITHER "Please reply to dbither@us.oracle.com" 21-MAY-1997 07:48:47.81
To: MEMORMAN
CC: BITHER
Subj: New Stars Article
TITLE: SQL/Services Supports up to 500 Columns in a Query
PRODUCT: SQL/Services (all versions)
OP/SYS: OpenVMS VAX, OpenVMS AXP
SOURCE: Oracle Worldwide Customer Support
PROBLEM:
You are using a PC query tool and SQL/Services to access an Oracle Rdb
database or an Oracle Rdb Distributed Option database.
Accessing the database results in a SYSTEM-F-ACCVIO access violation.
PROBLEM CAUSE:
This problem is caused by the number of columns being queried. If the
number of columns is greater than 500, then the access violation occurs.
If the number of columns is 500 or less, then the query works.
SOLUTION:
SQL/Services can only handle up to 500 columns in a query. Redesign your
queries to request no more than 500 columns at a time.
\
\ CONTRIBUTORS:
\
\ Technical: Diane Bither
| |||||