Unanswered: LONG columns at Oracle OLE DB: please HELP!!!
Do you know you the following problem and its solution?
It happens only with OLE DB.
I try to select one LONG column.
If the SELECT command contains only one table (for instance "select TEST_LONG from TEST_DATA where ..."), then I receive the full content of the field.
But if the command contains one more table (for instance "select TEST_LONG from TEST_DATA, TEST_DATA_DETAILS where ..."), then the field content is truncated!!
Now some details:
Use Oracle Ole DB to query the database.
It is easy to reproduce. Two easy tables:
CREATE TABLE TEST_DATA( ID NUMBER(7,0) NOT NULL , LONG_DATA_EXAMPLE LONG NULL);
ALTER TABLE TEST_DATA ADD ( CONSTRAINT PK_TEST_DATA PRIMARY KEY (ID));
CREATE TABLE TEST_DATA_DETAILS( ID NUMBER(7,0) NOT NULL , KUKU VARCHAR2(80) NULL);
ALTER TABLE TEST_DATA_DETAILS ADD ( CONSTRAINT PK_TEST_DATA_DETAILS PRIMARY KEY (ID));
Insert some records with equal IDs in both tables and make sure that the LONG column content is longer than 100.
Here is what happens:
"select TEST_DATA.long_data_example from TEST_DATA where TEST_DATA.ID = ?" I get the full content, everything is ok.
"select TEST_DATA.long_data_example from TEST_DATA, TEST_DATA_DETAILS where (TEST_DATA.ID = ?) AND (TEST_DATA.ID = TEST_DATA_DETAILS.ID)" I get back only the first 100 characters!