Thanks for the feedback.
So to investigate further why I get the error on TD 7.4.1, I tried to mimic the table structure (datatypes) and the SQL statement used and put that in a sample.
Also tested some SQL statements which are mentioned in this topic.
My conclusion is: the "normal" usage of binds in columns seem still to work in TD 7.4.1.
I did tests on TD 7.3.3 which does not fail. But running the test on TD 7.3.6 it shows the same error as in TD 7.4.1.
(So it could be broken somewhere between 7.3.3 and 7.4.1)
But in the specific situation here we use, I think, a special case:
- The column is a
- The SQL statement is an
So what is the case:
Multiple tables are joined (UNIONS) where only one table has a column of type varchar2(2000 BYTE).
The other tables do not have this column. So the UNION needs to specify the missing column in the SELECT statement.
I tried to create a sample application which is not the exact table structure and data we use here, but is using a similar construction.
This is the SQL statement in the sample application:
Code: Select all
SELECT ID, 1000 AS CODE, VALUE, DESCRIPTION
SELECT ID, 1001 AS CODE, VALUE, :lsMyLongData
INTO :nID, :nCode, :sValue, :lsDescription
ORDER BY ID, CODE
As can be seen, the column
is of type
and is only available in table
The second table which is joined has a bind variable at the place where the description should be.
The bind variable
is of TD type
and has no value (is empty).
Running the sample in TD 7.3.3 gives:
The error presented when using TD 7.4.1 (and TD 7.3.6):
Here the sample:
(Change the database settings in the Init function of the form to use your own database/user/password.
The button "Create table" will create the tables and insert some demo data.
The button "Select data" will execute the query and populate the child table on the form.)
I wonder if I need to report this to OpenText Gupta as it was solved by using "" in the select statement instead of using the bind variable.
You do not have the required permissions to view the files attached to this post.