Home » Developer & Programmer » Precompilers, OCI & OCCI » Help me! How to read LONG fileds when link two same tables?
icon4.gif  Help me! How to read LONG fileds when link two same tables? [message #209902] Mon, 18 December 2006 06:03
wokiluyar
Messages: 4
Registered: August 2006
Location: China
Junior Member
Hi, all
I'm developping an application. I have a table which has a "LONG" column. I need to run such sql by OCI:
SELECT "TEST_LONG"."CONTENT", "TEST_LONG_1"."CONTENT"
FROM "GUEST"."TEST_LONG" "TEST_LONG" INNER
JOIN "GUEST"."TEST_LONG" "TEST_LONG_1"
ON "TEST_LONG"."ID"="TEST_LONG_1"."ID"
The TEST_LONG_1 is an alias of TEST_LONG. The CONTENT is a "LONG" datatype column.
However, after executed the sql, I found that when reading rowset, the data returned is not correct. For example, the TEST_LONG has such data:
ID CONTENT
1 A
2 B

I get such result after execute:
CONTENT CONTENT
A B

It seems after I read out "A" for first column of rowset, I can not read "A" again. The first read of second column return "B" directly.
I don't know how to process this case. The problem is very urgent ! Would you like to give some advises? Thank you! Thank you very much!
Previous Topic: Error Pro*C - while trying to insert date using host variables
Next Topic: PRE- COMPILE Options
Goto Forum:
  


Current Time: Thu Mar 28 05:33:25 CDT 2024