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
Couldn't fetch more than one Long data in child table from ORACLE
Couldn't fetch more than one Long data in child table from ORACLE
You do not have the required permissions to view the files attached to this post.
Regards,
Sudhakar G
Sudhakar G
Re: Couldn't fetch more than one Long data in child table from ORACLE
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.
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.
Re: Couldn't fetch more than one Long data in child table from ORACLE
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
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
Who is online
Users browsing this forum: [Ccbot] and 3 guests