Home » Developer & Programmer » Forms » External e-mail problem
External e-mail problem [message #415209] Sun, 26 July 2009 06:17 Go to next message
imuharram
Messages: 48
Registered: January 2009
Member
I am using the attached package to send mail from forms through outlook to users who are using the application. the problem is that our users have no permission for external e-mails (receiving neither sending), and e-mails sent from the application can't be delivered to our users because of this issue.
I tried to grant myself permission for external e-mails and it worked perfectly well.

Any suggestions on how to solve this issue without granting users access to external e-mails?

[EDITED by LF: renamed the topic; the original title was "I". @imuharram, please, choose a descriptive title next time.]

[Updated on: Sun, 26 July 2009 15:58] by Moderator

Report message to a moderator

Re: External e-mail problem [message #415295 is a reply to message #415209] Mon, 27 July 2009 02:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Can they be granted permission to a single external email address?

David
Re: External e-mail problem [message #415302 is a reply to message #415295] Mon, 27 July 2009 03:09 Go to previous messageGo to next message
imuharram
Messages: 48
Registered: January 2009
Member
You mean having one user that has permission to external e-mails?
If yes, then yes we could ask them to create a user that has permission
Re: External e-mail problem [message #415361 is a reply to message #415209] Mon, 27 July 2009 06:49 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
imuharram wrote on Sun, 26 July 2009 16:47

I tried to grant myself permission for external e-mails and it worked perfectly well.



how did you grant permission to yourself???
Re: External e-mail problem [message #415367 is a reply to message #415361] Mon, 27 July 2009 07:23 Go to previous messageGo to next message
imuharram
Messages: 48
Registered: January 2009
Member
through the IT department

anyways I found the solution, by adding the following lines to the code I had in the first message

utl_smtp.command(g_mail_conn, 'AUTH LOGIN');
utl_smtp.command(g_mail_conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw(p_auth_user))));
utl_smtp.command(g_mail_conn,UTL_RAW.CAST_TO_VARCHAR2(utl_encode.base64_encode(utl_raw.cast_to_raw(p_auth_pwd))));

where p_auth_user is username of my e-mail account
and p_auth_pwd is the password of my e-mail account

Attached is the modified code
Re: External e-mail problem [message #415438 is a reply to message #415302] Mon, 27 July 2009 19:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No, what I meant was could your users be permitted to have access to internet addresses, then have all addresses 'blacklisted' using '*@*' as the mask, then have the one oracle originating address in the 'whitelist' of permitted addresses.

David
Re: External e-mail problem [message #415439 is a reply to message #415438] Mon, 27 July 2009 19:05 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The idea of having a special email account that DOES have external access and then use an Outlook macro to redirect any email that arrives in that email box. For example, place the real email address as the first line of the message or as part of the subject string.

David
Previous Topic: When mouse click trigger Problem
Next Topic: Auto fill text field if LOV has 1 record.
Goto Forum:
  


Current Time: Fri Dec 09 11:31:07 CST 2016

Total time taken to generate the page: 0.05109 seconds