Hi List,
To test some ways to play with HCC I try to create a procedure which
calls a kernels function:
in prvtcmpr.plb I found in the PACKAGE BODY prvt_compression
PROCEDURE KDZCHECKHI(HLID IN NUMBER);
PRAGMA INTERFACE (C, KDZCHECKHI);
PROCEDURE CHECK_HLI (HLID IN NUMBER);
...
PROCEDURE CHECK_HLI (HLID IN NUMBER) IS
BEGIN
KDZCHECKHI(HLID);
END;
...
I can not call CHECK_HLI directly, so I created:
~~~~~~~~~~~
create or replace PACKAGE bx_compression IS
PROCEDURE CHECK_HLI (HLID IN NUMBER);
END bx_compression;
/
create or replace PACKAGE BODY bx_compression IS
PROCEDURE KDZCHECKHI(HLID IN NUMBER);
PRAGMA INTERFACE (C, KDZCHECKHI);
PROCEDURE CHECK_HLI (HLID IN NUMBER) IS
BEGIN
KDZCHECKHI(HLID);
END;
END;
/
~~~~~~~~~~~
but when I try to test it:
exec bx_compression.check_hli(1);
BEGIN bx_compression.check_hli(1); END;
*
ERROR at line 1:
ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "SYS.BX_COMPRESSION", line 8
ORA-06512: at line 1
does anyone have a clue where I missed the copy&paste and introduced
my mistake?
thank you,
Martin