Help Me About [ PLS-00302: component 'SEND_MAIL' must be declared ] Error
Hello there,
i have a package in Master schema named 'Send_Mail'. i gave the permission of execution on procedure to the following users
GRANT EXECUTE ON send_mail TO mrp;
GRANT EXECUTE ON send_mail TO mrp1;
GRANT DEBUG,EXECUTE ON send_mail TO pns;
and created a procedure in mrp, mrp1, pns schema, which calls the 'Send_Mail' procedure.
this package is running successfully from mrp, mrp1 schema, but generating error in Pns schema as bellow
whenever i tried to create a procedure in pns that calls 'Send_Mail' package
PLS-00302: component 'SEND_MAIL' must be declared
i also granted dba, grant all on send mail to pns, but it's still generating this error. could you please tell me the reason
Regards,
Asif Iqbal
Software Engineer ( Karachi, Pakistan ).