SqlDbx Forum

garbuya

Member

Bug in VisualDiff

I'm trying to compare table structire in two databases. So I open VisialDiff, connected to 2 databases,  selected "Compare data" option and paste the following SQL which perfectly works in each database
SELECT TABLE_NAME,COLUMN_NAME,COLUMN_ID FROM DBA_TAB_COLUMNS WHERE OWNER='GARBUYA' AND TABLE_NAME IN
('MT_AP_VNDR_MSTR','MT_BRND_CLSFN','MT_CMPNY_VNDR','MT_CORP_MLT_UNIT','MT_CUST_MSTR','MT_DIV_NUM','MT_GL_ACCTS','MT_GL_RULES'
,'MT_IBM_AR_BILLTO','MT_IBM_CUST_ADDR_INFO','MT_IBM_CUST_NAME','MT_INDP_PROD_XREF','MT_LOC_MLT_UNIT','MT_OBIP_CONFIG','MT_PIM_CORP'
,'MT_PRNT_MLT_UNIT','MT_PROD_MSTR','MT_PURCH_FROM_VNDR','MT_PURCH_FROM_VNDR_XREF','MT_SIS_CMPNY_VNDR_XREF','MT_TIME_CORP','MT_USF_CLASS'
,'MT_USF_CTGRY','MT_USF_GRP','SR_CMPNY_VNDR_DFLT','SR_CMPNY_VNDR_PROD','SR_CMPNY_VNDR_PROD_DIV','CM_AGRMNT','CM_AGRMNT_ALW','CM_AGRMNT_ALW_RATE_GRP'
,'CM_AGRMNT_APPR','CM_AGRMNT_AP_TERMS','CM_AGRMNT_ATTCH','CM_AGRMNT_CMPNY_VNDR','CM_AGRMNT_ELIG_DIST','CM_AGRMNT_ELIG_VNDR','CM_AGRMNT_EXCL'
,'CM_AGRMNT_PGM_SIS','CM_AGRMNT_PO_HIST_DIST','CM_AGRMNT_PO_HIST_DIST_REB','CM_AGRMNT_PO_HIST_DTL','CM_AGRMNT_PO_HIST_DTL_REB','CM_AGRMNT_PROD'
,'CM_AGRMNT_PROD_EB','CM_AGRMNT_PROD_EB_RATE','CM_AGRMNT_RATE_GRP','CM_AGRMNT_RQST_DNI','CM_AGRMNT_RQST_DNI_EB','CM_AGRMNT_RQST_DNI_EB_HIST'
,'CM_AGRMNT_RQST_DNI_HIST','CM_AGRMNT_SEQ','CM_CLUSTER','CM_CLUSTER_DIV','CM_EXCL_RSN','CM_VPP','CM_VPP_BRND','CM_VPP_CLS','SIS_EB_PROD_VNDR'
,'SIS_ELIG_DIST','SIS_ELIG_PROD','SIS_ELIG_VNDR','SIS_PGM_MSTR','SIS_PGM_NOTES','SIS_REB_PGM','SIS_RTE_GRP','SR_PO_HIST_DTL')
ORDER BY TABLE_NAME, COLUMN_ID

I'm getting error "ORA-01756: quoted string not properly terminated"
When I made this list shorter it works.
It looks like there is a limitation on the size of entered text in these windows.

sqldbxhelp

Administrator

Re: Bug in VisualDiff

That is correct.
Text length limit will be removed in a next release.