...
CREATE OR REPLACE package body package1 is
procedure test_proc(p_inn varchar2,
                            p_cursor out sys_refcursor) is 
...

DECLARE
    p_inn varchar2(50) := '771603983483';
BEGIN
    package1.test_proc@dblink(p_inn,:p_cursor);
END;
ORA-24338: указатель оператора не выполнен

CREATE OR REPLACE package EGRIP_IMPORT.p_test is
    type test_rowGet is record (fnum numeric, fvar varchar2(100 char), fdate date);
    type test_table is table of test_rowGet;
    function get_test_table RETURN test_table pipelined;
end;
CREATE OR REPLACE PACKAGE BODY EGRIP_IMPORT.p_test
AS
    function get_test_table RETURN test_table pipelined
    is
    begin
        for curr in
        (
            ---- fnum numeric, fvar varchar2(100 char), fdate date
            select 12 as fnum, 'qwerqwerqwer' as fvar, to_date('12.01.2017','dd.mm.yyyy') as fdate from dual
            union all
            select 4 as fnum, 'zxcvzxvzxv' as fvar, to_date('05.01.2014','dd.mm.yyyy') as fdate from dual
        )
            loop pipe row(curr);
        end loop;
    end;
end;

SELECT * FROM TABLE(P_TEST.get_test_table@dblink);
ORA-06553: PLS-752: Табличная функция GET_TEST_TABLE находится в противоречивом состоянии.