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.