Oracle RDF report error ORA-01789 query block has incorrect number of result columns
Hi ,
I am trying to add new column to existing RDF report query, The query has lexical parameter with UNION ALL that get the query dynamically. Even though I have added the column to dynamic sql clause ,I am getting the below error when I try to add new column to first sql shown below. Can any one please let me know if I am missing anything else here?
SELECT 0 CUSTOMER_TRX_ID
, rpad('a',20,'-') TRX_NUMBER
, 0 TERM_SEQUENCE_NUMBER
, rpad('a',40,'-') TRX_TYPE
, rpad('a',80,'-') TRX_TYPE_NAME
, 'a' OPEN_RECEIVABLE_FLAG
, sysdate TRX_DATE
, 0 SHIP_TO_CUSTOMER_ID