•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 426,411 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,335 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 2608 | Replies: 0
![]() |
•
•
Join Date: Aug 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
ERROR OCOURED-29279->ORA-29279: SMTP permanent error: 500 Access Denied By Port Acces
#1
Aug 8th, 2007
HI here is the code which gets the error message
"ERROR OCOURED-29279->ORA-29279: SMTP permanent error: 500 Access Denied By Port Acces"
please do help me in this regards
thanks in advance
CREATE OR REPLACE PROCEDURE s_test
AS
l_name VARCHAR2 (1000) := '';
conn UTL_SMTP.connection;
send_from VARCHAR2 (1000) := 'aldrin.vas@hotmail.com';
send_to VARCHAR2 (1000) := 'suresh.g@gmail.com';
BEGIN
FOR x IN (SELECT file_name filename,
MAX (source_file_date) last_loaded_date
FROM audit
GROUP BY file_name
HAVING MAX (source_file_date) < TRUNC (SYSDATE) - 1)
LOOP
l_name := x.filename;
conn :=
str.stars_mail.begin_mail (sender => send_from,
recipients => send_to,
subject => 'RDP Audit',
mime_type => 'TEXT/HTML'
);
str.stars_mail.write_text (conn => conn, MESSAGE => l_name);
str.stars_mail.end_mail (conn => conn);
DBMS_OUTPUT.put_line ('Mail sent');
END LOOP;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('ERROR OCOURED' || SQLCODE || '->' || SQLERRM);
END;
/
"ERROR OCOURED-29279->ORA-29279: SMTP permanent error: 500 Access Denied By Port Acces"
please do help me in this regards
thanks in advance
CREATE OR REPLACE PROCEDURE s_test
AS
l_name VARCHAR2 (1000) := '';
conn UTL_SMTP.connection;
send_from VARCHAR2 (1000) := 'aldrin.vas@hotmail.com';
send_to VARCHAR2 (1000) := 'suresh.g@gmail.com';
BEGIN
FOR x IN (SELECT file_name filename,
MAX (source_file_date) last_loaded_date
FROM audit
GROUP BY file_name
HAVING MAX (source_file_date) < TRUNC (SYSDATE) - 1)
LOOP
l_name := x.filename;
conn :=
str.stars_mail.begin_mail (sender => send_from,
recipients => send_to,
subject => 'RDP Audit',
mime_type => 'TEXT/HTML'
);
str.stars_mail.write_text (conn => conn, MESSAGE => l_name);
str.stars_mail.end_mail (conn => conn);
DBMS_OUTPUT.put_line ('Mail sent');
END LOOP;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('ERROR OCOURED' || SQLCODE || '->' || SQLERRM);
END;
/
![]() |
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- "Forbidden / You don't have permission to access / on this server." error (Linux Servers and Apache)
- 500 internal server error (*nix Software)
- ORA-12157 error when installing Oracle 10g on Fedora 5 (Oracle)
- rundll32 error (WIN98SE) when trying to change the display setting (monitor) (Windows 9x / Me)
- URGENT: JSP - StackOverFlow Error (JSP)
- Http 500 -internal Server Error (Site Layout and Usability)
- another newbie with alot of redhat and apache server Q'S (Linux Servers and Apache)
- Cant figure this error out: "The page you requested, has produced an error" (ASP)
- Error message when trying to load Windows XP from a CD! HELP! (Windows NT / 2000 / XP / 2003)
- get an error while viewing .aspx page (ASP.NET)
Other Threads in the Oracle Forum
- Previous Thread: increasing process
- Next Thread: Trying to pull and display records from today back 30 days....


Linear Mode