ORA-02069: global_names parameter must be set to TRUE
441198Jul 15 2008 — edited Jul 15 2008Hi,
I am getting the ORA-02069: global_names parameter must be set to TRUE for this operation error on the following query when I try to create a report region. The database link works fine in queries where I don't reference the collection. It must be because of the presence of local and remote references in the query. How do I get around this? Do I need to set global_names to true in the local db?
select t.*, c.*
FROM all_tab_columns@xxxxx_link t, htmldb_collections c
WHERE t.table_name = c.c001 (+)
AND t.column_name = c.c002 (+)
AND t.table_name = UPPER(:P3_TABLES)
AND c.collection_name (+) = 'SQL_SEARCH_COLLECTION'
Many thanks,
Donal.