Couldn't fetch more than one Long data in child table from ORACLE

Report TD 5.x and 6.x bugs and possible workarounds.
seesu12
India
Posts: 1
Joined: 14 Mar 2017, 11:32
Location: Chennai, India

Couldn't fetch more than one Long data in child table from ORACLE

Post by seesu12 » 10 Apr 2017, 09:45

Hi,

I just tried to populate more than one LONG data type columns in child table or grid, but unfortunately only one column fetching the value others are blank. I tried both SalTblPopulate and used variables but no luck. But it's working in SQL Server. whether the Child Table and Grid has the same limitation like ORACLE (Only one LONG column in a table).

For time being separate the select statement into multiple for every Long column(every select has one Long column). Please help me to sort out this issue.

Find attached sample file (Use your DB, Username and password).

CREATE TABLE LONG_TEST( TESTID VARCHAR2(35), TESTDATA LONG);

INSERT INTO LONG_TEST
select 'DATA_ROW01_COL01', 'Value of the first column' from dual
Union all select 'DATA_ROW01_COL02', 'Value of ther second column' from dual
Union all select 'DATA_ROW01_COL03', 'Value of ther third column' from dual
Union all select 'DATA_ROW02_COL01', 'Value of ther first column' from dual
Union all select 'DATA_ROW02_COL02', 'Value of ther second column' from dual
Union all select 'DATA_ROW02_COL03', 'Value of ther third column' from dual;

Query Used:
SELECT Col1.TESTID, Col1.TC1, Col2.TC2, Col3.TC3 FROM
(SELECT TESTID, TESTDATA TC1 FROM LONG_TEST WHERE TESTID= 'DATA_ROW01_COL01' ) Col1,
(SELECT TESTID, TESTDATA TC2 FROM LONG_TEST WHERE TESTID = 'DATA_ROW01_COL02') Col2,
(SELECT TESTID, TESTDATA TC3 FROM LONG_TEST WHERE TESTID = 'DATA_ROW01_COL03') col3
ORDER BY 1;

Regards,
Sudhakar G
You do not have the required permissions to view the files attached to this post.
Regards,
Sudhakar G

Christof
Germany
Posts: 9
Joined: 06 Mar 2017, 07:27
Location: Frankfurt, Germany

Couldn't fetch more than one Long data in child table from ORACLE

Post by Christof » 12 Apr 2017, 09:47

Just a guess...
I believe that the Gupta Oracle Router sqlora32.dll only regards one LONG column since Oracle allowed only one LONG column per table.
The reason I am writing "allowed" is, that Oracle advised against using the LONG datatype since Oracle8i, you better should use one of the LOB-Types.
Since TD6.0 we've experienced strange results regarding the length of fetched data from LONG columns.

Didiman
Germany
Posts: 176
Joined: 21 Mar 2017, 13:05
Location: Bremen, Germany

Couldn't fetch more than one Long data in child table from ORACLE

Post by Didiman » 03 May 2017, 10:43

Hi,

just took a look into your Sample. IMO it wont work at all without using Call SqlSetLongBindDatatype( ). We have a lot of long string columsn in our Helpdesk-App. There is no Problem with it at all.

Greeetz

--Andreas

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests