890:
891: IF p_schema <> 'NONE' THEN
892: SELECT count(*)
893: INTO l_both
894: FROM dba_tab_columns col,
895: user_synonyms syn
896: WHERE syn.synonym_name = p_table
897: AND col.owner = syn.table_owner
898: AND col.table_name = syn.table_name
905: ELSE
906:
907: SELECT count(*)
908: INTO l_secondary
909: FROM dba_tab_columns col,
910: user_synonyms syn
911: WHERE syn.synonym_name = p_table
912: AND col.owner = syn.table_owner
913: AND col.table_name = syn.table_name