create or replace PROCEDURE PROC_EU_TABLE_COMPARE (
R_CURSOR OUT SYS_REFCURSOR,
SRC_SCHEMA_NAME         IN VARCHAR2,
TGT_SCHEMA_NAME         IN VARCHAR2
)

IS


CNT3 NUMBER;
SQL_TEXT3 VARCHAR2(4000);

BEGIN

--SRC_SCHEMA_NAME      := UPPER(SRC_SCHEMA_NAME);
--TGT_SCHEMA_NAME      := UPPER(TGT_SCHEMA_NAME);


SQL_TEXT3:='SELECT * FROM
((SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME =''%EU%'' AND OWNER ='''||SRC_SCHEMA_NAME||'''
        MINUS
        SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME LIKE ''%EU%''AND OWNER ='''||TGT_SCHEMA_NAME||''')
        UNION
        (SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME LIKE ''%EU%''AND OWNER ='''||TGT_SCHEMA_NAME||'''
        MINUS
        SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME =''%EU%'' AND OWNER ='''||SRC_SCHEMA_NAME||'''))';

        EXECUTE IMMEDIATE SQL_TEXT3 INTO CNT3;
        DBMS_OUTPUT.PUT_LINE(CNT3);

END;