SQL & PL/SQL

Hi Experts,

When i do union ALL for CLOBS, I am getting results null though both columns are having data.

I tried it in simple way taken out small query and executed outside, it works but in my main query its not coming.

Thanks

Ex:

WITH TEMP_TEST AS (

SELECT MEMBERNAME,FORMULA FROM

SOURCE_EXTRACT WHERE MEMBERNAME = '1'),

TEMP_TEST2 AS (

SELECT MEMBERNAME,FORMULA FROM

SOURCE_EXTRACT WHERE MEMBERNAME = '1'),

TEMP_TEST3 AS (

SELECT A.MEMBERNAME SRC_MEMBERNAME,

       A.FORMULA SRC_FORMULA,

       B.FORMULA TGT_FORMULA,

       B.MEMBERNAME TGT_MEMBERNAME

FROM TEMP_TEST A, TEMP_TEST2 B WHERE A.MEMBERNAME = B.MEMBERNAME)

SELECT SRC_FORMULA FORMULA  FROM TEMP_TEST3 WHERE SRC_MEMBERNAME = '1';

UNION ALL

SELECT TGT_FORMULA FORMULA  FROM TEMP_TEST3 WHERE TGT_MEMBERNAME = '1';

With above query i do get Formulas, same logic i have kept in main query only for Formulas i do get NULL's other columns i am getting values.

Thanks