Our installation is using CocoBase 4.5.
Can you please tell me what the Cocobase XML map definition would look like for this select statement? The issue is how to bind the variable COLUMN_01 for the inner select. If I specify :COLUMN_01 within the map for the inner select where clause, I get a "ORA-01008: not all variables bound" error. I know that there may be alternatives within the Cocobase software to accomplish the same result but without stating the details, I would like to implement this within the map definition itself.
thank you
SELECT
RN,
COLUMN_01,
COLUMN_02,
COLUMN_03
FROM
(
SELECT
ROWNUM RN,
COLUMN_01,
COLUMN_02,
COLUMN_03
FROM
TABLE_NAME
WHERE
COLUMN_01 = 'ABCDEF'
ORDER BY
COLUMN_02
)
WHERE
RN BETWEEN 2 AND 4;
|