SmartRefresh

acabrera · Post by **acabrera** » Thu 15 Sep 2005 17:40

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.

Alex · Post by **Alex** » Fri 16 Sep 2005 07:37

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.