[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] RE: Oracle LONG data type processing

Just guessing.
Try to issue statement: set long (some number). Reduce (some number) if you 
still getting error. 

ruscs ___ <ruscols@hotmail.com> wrote:
Hello,

I am using SQR ODBC Version 8.0.2 And I am creating a few flat files 
containing columns with Oracle LONG data type (Oracle db is the source). 
Further, I am getting the following error (with LONG data type) while trying 
to select rows within Begin-Select...End-Select construct:

(SQR 5528) ODBC SQL dbexec: SQLExecute error 1459 in cursor 3:
[Oracle][ODBC][Ora]ORA-01459: invalid length for variable character 
string
Error on line 57:
(SQR 3723) Problem executing cursor.
SQR: Program Aborting.
-------------------
Obviously, I can't increase the record size because the script does not 
compile:

Open $FileName as 1 For-Writing Record=32767:vary Status=#OpenStat
....

In addition, I have two PCs w/ different versions of Oracle ODBC driver and 
I have run my scipts on both of these PCs. One of these driver versions is 
8.01.07.00
I do not get the above error with this driver.
The other driver version is 9.02.00.65. And this is the driver version that 
I am having trouble with...
Please help me resolve this problem...
Thank you,
Ken



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

                
---------------------------------
Yahoo! for Good
 Click here to donate to the Hurricane Katrina relief effort. 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users