oracle 10g - utl_mail package
i'm carrying bit problem utl_mail package seer 10g, wondering anyone any solutions?
i bond db sysman bucket following twin scripts;
@c:\oracle\product\10.2.0\db_1\rdbms\admin\utlmail.sql
@c:\oracle\product\10.2.0\db_1\rdbms\admin\prvtmail.plb
i set adult smtp server;
alter component set smtp_out_server='mymailserver.fake:25' scope=both;
i extend user mandatory permission;
grant govern utl_mail myuser;
but following i bond "mytablespace" (where myuser exists), i following blunder i anxiety utl_mail.send;
pls-00201: identifier 'utl_mail.send' contingency declared
if i prefix sysman nonetheless (sysman.utl_mail.send), works, nonetheless i don't wish way contains trust tablespace hallowed scripts.
is there proceed exercise scripts permitted universally, need sysman prefix execute?
cheers,
chris
Comments
Post a Comment