Devart Forums

I'm using Delphi 7, ODAC and Oracle 9i. My program uses a SmartQuery and I set its SmartRefresh property to true. When I run the project, I get the error message:
Project ... raised exception class EOraError with message ORA-06550
PLS-00201: identifier DBMS_ALERT must be declared

When SmartRefresh is false, I do not get an error but the datasets are not synchronized.

You need to allow your current Oracle user to use DBMS_ALERT package. To do this connect as Sys user (SYSDBA role) and execute 'GRANT EXECUTE ON DBMS_ALERT TO your_Oracle_user_name' command.