Application Express :: 4.2 - Oracle Apex_Mail Send
Nov 6, 2012
I am using oracle apex 4.2 version.i am trying to send mail using APEX_MAIL.send.My process like
begin
APEX_MAIL.send(
p_to => 'xxx@xxx.com',
p_from => 'xxx@xxx.com',
p_body => l_body,
p_subj => 'APEX_MAIL Package - Plain Text message');
end;
When i check mail queue from administrator part HomeManage > InstanceMail > Queue
It show no error and after the send all mail still i am not getting the mail..i also check my email setting in administrator part.
View 1 Replies
ADVERTISEMENT
Sep 30, 2013
We just upgraded to APEX 4.2.2.00.11 and we are getting ORA-24247: network access denied by access control list (ACL) errors form apex_mail. This had been working correctly prior to the upgrade.
View 4 Replies
View Related
Jul 17, 2012
Can't send an email using Application Express 3.0.1.00.07 on oracle 10g.
my code is:
DECLARE
l_body CLOB;
v_email varchar(30);
BEGIN
SELECT CONTACT_EMAIL
INTO v_email
FROM persal_info
WHERE TRIM(PERSAL)= TRIM(:P48_PERSAL);
l_body := 'Your access code for the Transport system is:'|| :P48_CODE ;
l_body := l_body || '
This access code is needed in order for you to complete the claim form. It is important to change this access code for the confidentiality of your information.';
apex_mail.send( p_to => v_email,
p_from => 'PietC@google.com',
p_body => l_body,
p_subj =>'Access Code'
);
View 1 Replies
View Related
Mar 8, 2013
Is there some simple solution how to send email to user with link ('I don't want to receive emails from you in the future') ?
The link should contain some key information for each user.
If user click the link - update of the table should be done. (some IDC updates from 'Y' to 'N').
Specs: APEX 4.1.1
Listener 1.1.3
DB 11G
Apache Tomcat 6.0
View 1 Replies
View Related
Feb 25, 2013
I am able to send mail to Gmail from APEX. How an attachment can be send along with it.
View 6 Replies
View Related
Sep 16, 2013
I am beginner . I found this tutorial how to save and access report.Storing and Accessing Reports in the Database In that tutorial report is saved onclick.Is there a way to automatically email report everytime report is generate or I should first save it (PDF, CSV,..) with SQL script and then email it? I also found that in Interactive report there is page process that can send e-mails. Is it possible that page process send e-mail with report or report should be also saved before sending? The reason for this is that we want to have a history of created reports.
View 6 Replies
View Related
Dec 28, 2012
I want to add button on report region Named as "Send E-mail" that should be on each row
so how can i do?
View 8 Replies
View Related
Sep 12, 2013
We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,
Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.
View 1 Replies
View Related
May 28, 2013
I want to send an email from my Application forms 10g .But I receive
DECLARE
l_mailhost VARCHAR2(64) :=... //admin mail
l_from VARCHAR2(64) := ... //admin mail
l_to VARCHAR2(64) := ...//user mail
l_mail_conn sys.UTL_SMTP.connection;
[Code] ........
message displayed is: no internet connection !!
View 3 Replies
View Related
Sep 8, 2013
What is the best way to send the output of a PL / SQL function / procedure to the application in Oracle 11g. I understand that it could be different for applications built in JAVA , .Net , SAP etc.
View 49 Replies
View Related
Aug 7, 2012
This time i am downloading the Oracle 11g and then the Oracle APEX...(they are not in one package...right ? i mean they both have to download separately)i really new in oracle / PL/SQL. I'm not a programmer but i interest about database programming.For now i still use Ms. Access to develop an aplication and i really suprised i found this Oracle APEX because it an RAD tool too same as Access but more powerfull i think.
View 2 Replies
View Related
Jan 1, 2013
I am trying to use the APEX (as a substitute for my PHP forms base application) for a new client. Can I use the APEX and Oracle XE in production, without spending any money for a license from Oracle - i.e. for listener, Web server, etc,?
I already have setup the APEX that works fine on my laptop, able to see and work with the form on the browser, so can I take the same to a server as a production?
View 4 Replies
View Related
Nov 13, 2013
I have downloaded Oracle 11g XE and installed it on my laptop, Win 7 Enterprise Everything works great, DB admin page comes up, APEX comes up (4.0.2.x). I download the Apex_4.2.3_en.zip. I extract the zip file and then follow the instructions in, Downloading from Oracle Technology Network essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock.
This is the install command, @apexins SYSAUX SYSAUX TEMP /i/
I get the Error processing request ORA-010403: no data found.
View 3 Replies
View Related
Dec 17, 2012
I am going for a presentation at my University. But the students are not very interested in Oracle or Databases. So I need a title for the Apex topic which gets the other students to visit my presentation.
The presentation should show the basics of apex and how to earn money with this.I thought of:
1) Oracle in the world of Web 2.0
2) How to get online with Oracle
3) What to show if some1 tells you Access is a Database
4) Oracle in a drag and drop environment even for developers
5) Best of Breed: Oracle SQL / PL/SQL, HTML, XML and Java in a nutshell
View 8 Replies
View Related
May 21, 2013
Tried installing APEX 4.2 with Oracle EBS 12.1.3. I have installed APEX into the Oracle EBS database (11.2.0.3)
I am trying to install the APEX listener on the Web Tier however it starts the listener and gives the url as
[URL]........
Is there a way to set this with actual hostname of the server.
View 2 Replies
View Related
Jul 7, 2012
We can send E-mail through Oracle DB, can we send SMS through Oracle DB to any Mobile No.
View 1 Replies
View Related
Mar 5, 2012
i am sending { Daily Status } via E-Mail by Oracle 10g,,,,
now My client want to Receive By sms to his mobile ,,,
Is there any possibilities to sent sms by oracle 10g ,,if exists pls sent the Code,,,or any procedure to sent sms via Oracle 10g
View 11 Replies
View Related
Nov 24, 2012
I need to export my whole workspace/application from Oracle Application Express so if i was to move onto a new pc and install oracle again. I can import this file and everything will be as it was without need of editing anything.
Is this possible if so how? - Preferably export into 1 big file so importing will be with 1 mouse click instead of exporting to seperate database files etc.
View 2 Replies
View Related
Dec 11, 2012
I the past when working with apex 3 I was able to work with apex mail send very nice. In apex 4.0 with oracle 11g ee I'm not able to send emails anymore.
Last error message in the queue is:
ORA-29279: SMTP permanent error: 550 through this server without authentication.
the smtp server has not been changed, the code is fine. How I can go further?
View 20 Replies
View Related
Nov 2, 2012
Can i setup 2 node oracle RAC using vmware server in a single laptop..? cpu-intel i3 memory 4GB.
View 1 Replies
View Related
Sep 21, 2012
I have two reports in one page.One is the Interactive and other is Sql report. Based on the selection of the row(using checkbox) in the interactive report, the sql report has to display the selected columns.
Note :The report has to be loaded whenever a row is selected and without submitting a button.
View 3 Replies
View Related
May 29, 2013
From report attribute ,in layout and pagination section.I have selected one pagination template,where 1,2,3 numbers are displayed (customize css).Now when number of records in report are very few,still I am able to see page 1,which I dnt want.
.classname li:first-child{
display:none
}
this is not working.
View 0 Replies
View Related
Jan 7, 2013
We had a query whether, oracle apex 4.0 and above is IPv6 compatible or compliant ? We use Oracle apache HTTP Server as the application server and oracle 11G database.
View 3 Replies
View Related
Apr 24, 2013
what is the best way to send an email in oracle?
1.utl_smtp
2.utl_mail
3.utl_tcp
View 6 Replies
View Related
Feb 4, 2013
I have successfully implemented the from which I can send SMS using Forms 6i and any mobile modem connected with OS.Now you can send SMS using Oracle Forms 6i.
View 15 Replies
View Related
Jul 26, 2011
I had a question :
How to send mail from Oracle ??
Implement utl_mail??
How to implement ?? , or have any examples for reference??
View 6 Replies
View Related
Dec 12, 2012
I cannot remember my password to access an existing database in Application Express. I tried entering my password 3 times, but the system does not provide a status other than 'Invalid Login Credentials'.
I am going to assume that 3 times is limit before you have to reset the password or from what I see reinstall. When selecting reset, the system asks for an email address that was never established in the system. How can I reset my password without uninstalling and reinstalling Oracle 11g XE?
View 10 Replies
View Related
May 24, 2013
In Oracle Apex 5 SOD it says it will have the following feature:
"New Multi-Row Edit Region Type – Define a new region type with a modern UI for updating multiple rows of data and allow multiple regions on one page"
[URL].......
If so, how likely it will allow dynamic query (PL/SQL) in addition to simple query? Also, how likely it will include advanced features like frozen columns with group headers, subgrid, etc.? It will be nice if the grid will adjust itself based on the width of the screen.
View 2 Replies
View Related
Jan 3, 2013
I have enabled SSO for my application. It was working in 4.1 version. I have upgraded to 4.2 now and the same code doesn't work now.I have created an authentication scheme where i check if a particular person is an employee based on a flag. If he is, then I return 1 to the authorization scheme i have created. This always returns 0 even if the flag is set to 'Y'. I have tried hard coding the user_id as well. It doesn't work.
I tried printing the :APP_USER but it does not give any output.
View 1 Replies
View Related
Dec 21, 2009
Am trying to send email from Oracle using utl_smtp.
My issue is regarding Arabic character. I set the charset to windows-1256 and even tried with other different charset like UTF-8.
I used also: utl_smtp.write_raw_data(l_connection,utl_raw.cast_to_raw(dbms_lob.substr(data).
Before i set all these changes to the procedure i was receiving the Arabic text as '??????'
However, after above modifications, the text display changed to something like this : ÇäÇÓààååÑêå
Does the problem still in the DB side or it can be coming from mail server ?
View 24 Replies
View Related