[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:	Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:	RDB_60 is archived, please use RDB_70..
Moderator:	NOVA::SMITHISON

Created:	Fri Mar 18 1994
Last Modified:	Fri May 30 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	5118
Total number of notes:	28246

4963.0. "size of SQLVAR in Dynamic SQL" by 3583::ZION () Mon Jan 27 1997 04:05

    a customer is trying to construct the SQLDA and have the SQLVAR
    to contain more than 150 fields.
    the table contains some 225 fields, and it seems to fail past the 150
    
    Anyone knows the limit of the SQLVAR size in dynamic SQL?
    
    Thanks in advance.

T.R Title User Personal
Name Date Lines

4963.1 NOVA::SMITHI Don't understate or underestimate Rdb! Sat Feb 01 1997 15:51 10

T.R	Title	User	Personal Name	Date	Lines
4963.1		NOVA::SMITHI	Don't understate or underestimate Rdb!	`Sat Feb 01 1997 15:51`	10
	The length of the array can be virtually unlimited. Please make sure they set the length correctly. Take a look at the SQL$DYNAMIC example in the examples ~it seems to fail past the 150 What do you mean fail? Is there an error message? If so please give the full text of the message. Ian

The length of the array can be virtually unlimited.  Please make sure they set
the length correctly.  Take a look at the SQL$DYNAMIC example in the examples


~it seems to fail past the 150

What do you mean fail?  Is there an error message?  If so please give the full
text of the message.

Ian