ERROR: ORA-02019: connection description for remote database not found
Hi All,
Please help on the below error.
ERROR:
ORA-02019: connection description for remote database not found
ORA-02063: preceding line from EDWTX03@TRAFFIC_OWNER
I am getting the above error when I try to run the below query.
The query works fine when I remove the seq_tap_td_imsi_id.NEXTVAL. The owner of this sequence and package are same. They exist on the same schema.
In the FROM clause, I have a local table (calendar_time) and a remote table (TAP).
problem query from package:
-------------------------------
SELECT seq_tap_td_imsi_id.NEXTVAL, -- sequence in local database/schema
....
FROM (
SELECT /*+ DRIVING_SITE (T) NO_MERGE FULL(t) FULL(ct) */
....
FROM
tap --remote_table accessed by dblink -> synonym remote database
, calendar_time ct -- table local database/schema
WHERE t.source_system_id = '016'
....
GROUP BY to_number(to_char(t.charge_start_date, 'YYYYMMDD')),
....
Please.
Let me know if you need more information.
Thanks in Advance.