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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members