I have procedure which calls function on the another schema using dblink.
I get error : ora-06550: identifier "package_name.procedure_name@dblink_name" must be declared".
Both procedure and function are in the pl/sql packages.
DBLink is setup correctly (select statements work perfect)
I've found that this can be problem with roles and I added clause 'AUTHID CURRENT_USER' next to 'CREATE OR REPLACE PACKAGE' but it doesn't help.