Devart Forums

Hello.

I have problem with executing DBMS_STATS.GATHER_TABLE_STATS:

SP: uni.TUniStoredProc;

1)
SP:=TUniStoredProc.Create(Application);
SP.StoredProcname:='DBMS_UTILITY.COMPILE_SCHEMA';
SP.Prepare; // OK
2)
SP:=TUniStoredProc.Create(Application);
SP.StoredProcname:='DBMS_STATS.GATHER_index_STATS';
SP.Prepare; // OK
3)
SP:=TUniStoredProc.Create(Application);
SP.StoredProcname:='DBMS_STATS.GATHER_table_STATS';
SP.Prepare; // ERROR: 'Object SYS.DBMS_STATS.GATHER_table_STATS does not exist'

4) TOAD (same Oracle user)
begin
DBMS_STATS.GATHER_TABLE_STATS(user,'CAKCE');
end; -- OK

WHY?

Unidac 6.03.13
Delphi XE5
Oracle 12.1 SE

Thanks in advance

Unfortunately, we couldn't reproduce the described issue. Please check the needed behavior using the current UniDAC version 6.4.14 (08-Sep-16). In addition, make sure again, that parameters of the environment you are using on attempt to execute the DBMS_STATS.GATHER_table_STATS procedure are the same for the used utilities in UniDAC.