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

Application Express :: 4.2.2 Upgrade Now Giving Apex_mail ORA_2427 ACL Error

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

Application Express :: Can't Send Email Using 3.0.1.00.07 Oracle 10g

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

Application Express :: Send Link To Update Some Record

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

Application Express :: Send Mail To GMAIL With Attachments

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

Application Express :: How To Automatically Send Report After It Is Created

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

Application Express :: Add Button On Report Region Named As Send Email

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

Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation

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

Forms :: 10g - Send Email From Application?

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

PL/SQL :: Best Way To Send A Procedure / Function Output To The Application

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

Application Express :: Downloading Oracle 11g And Then Oracle APEX

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

Application Express :: Oracle XE In Production

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

Application Express :: Oracle 11g XE - 4.2.3 Upgrade

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

Application Express :: How To Get Online With Oracle

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

Application Express :: 4.2 Configuration With Oracle EBS R12

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

Send SMS Through Oracle DB?

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

SQL & PL/SQL :: Send SMS Via Oracle 10g?

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

Export Whole Workspace From Oracle Application Express

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

Application Express :: Sending Email From 4.0 With Oracle 11g Ee

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

Application Express :: Oracle 11gr2 RAC 2 Node

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

Application Express :: 4.0 - Dynamic SQL Report On Oracle

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

Application Express :: Customize Pagination In Oracle

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

Application Express :: Oracle 4.0 And IPv6 Compatible

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

SQL & PL/SQL :: Send Email In Oracle?

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

Forms :: Send SMS Using Oracle 6i

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

SQL & PL/SQL :: How To Send Mail From Oracle

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

Application Express :: Oracle 11g XE - Retrieve Or Reset Password

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

Application Express :: Oracle Apex 5 SOD - Multiple Regions

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

Application Express :: Oracle SSO Authorization Not Working After Upgrade To 4.2.1

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

SQL & PL/SQL :: Send HTML Email From Oracle?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved