What is SYS.DBMS_ALERT?

[gordoncutts]

Hello everyone. I apologize for the very basic sounding question, but I come from a VOIP background .. no database work there! I am working with Delphi 5.0 and want to add a timeout event for an Oracle session. I have managed to set everything up according to the demo I saw, however I don't understand what needs to be done to address the error 'Identifier SYS.DBMS_ALERT must be declared'. Any help would be greatly appreciated.

Thanks to all.

Sincerely,

Gordon Cutts

gordonc.nospam@bosmedtech.com (take out '.nospam' for direct emailing).

 

[jpickup]

dbms_alert is a package owned by sys. It contains functions related to alerts.

To fix your problem log in as sys and submit the following command:
GRANT EXECUTE ON sys.dbms_alert TO public;

public is a role that everyone has, you could grant the execute right to a particular role or user if you like.

[This message has been edited by jpickup (edited 22 February 2002).]

 

[gordoncutts]

Excellent. This is very much appreciated! I will get the DBA to give it a try.