ORA-24247 Error

Today get the next error when create a new procedure that send a mail from database.

ORA-24247 Calling UTL_SMTP or UTL_HTTP or UTL_TCP

The problem is that version is 11g, and use ACL control. We need direct access (using dbms_network_acl_admin package) or using the “AUTHID  CURRENT_USER” clause;

CREATE PROCEDURE proc_name (…..) AUTHID CURRENT_USER AS

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s