DBMS_COMPRESSION.get_compression_ratio ORA-00933 error
Hi,
Trying to work out compression level for a large table but I am getting the following error when trying to run DBMS_COMPRESSION.get_compression_ratio.
Running Oracle Database 19c Enterprise Edition 19.11.
DECLARE
2 l_blkcnt_cmp PLS_INTEGER;
3 l_blkcnt_uncmp PLS_INTEGER;
4 l_row_cmp PLS_INTEGER;
5 l_row_uncmp PLS_INTEGER;
6 l_cmp_ratio NUMBER;
7 l_comptype_str VARCHAR2(32767);
8 BEGIN
9 DBMS_COMPRESSION.get_compression_ratio (
10 scratchtbsname => 'HMF_STATIC',
11 ownname => 'BARB_2010',
12 objname => 'PN_PANELISATION_OUTPUT',
13 subobjname => NULL,
14 comptype => DBMS_COMPRESSION.comp_basic,
15 blkcnt_cmp => l_blkcnt_cmp,
16 blkcnt_uncmp => l_blkcnt_uncmp,
17 row_cmp => l_row_cmp,