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


ADVERTISEMENT

SQL & PL/SQL :: How To Connect Oracle 10g Database Through Online

Dec 8, 2011

how to connect oracle database through online

View 8 Replies View Related

Forms :: Using Online Software Developed By Oracle 6i And 10g XE?

Oct 10, 2012

I developed an Point of sales software using developer 6i and database 10g XE.Now I want to use this software online. Can I do it ? If it is, then how?

View 1 Replies View Related

Recovery Manager (RMAN) :: Online Backup Scripts For Oracle 11g On Windows?

Jul 25, 2013

,I am new to Oracle database administration i am working on a 24*7 tool .the tool will work as a non stop.this is a standalone tool.there wont be any one who will be taking care of the database.I need to design a backup statergyNeed to take backups on timly basis.Since the database can't be go offline cold backup's can not be useenhot backup needs to implemented.what are steps needs to do for hot backup.Is there are some pre defined scripts to run the backup.

View 6 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

Real Application Clusters :: UDLM Rac-udlm-rs Failing To Come Online

Jul 1, 2013

I'm setting up a zone cluster that will be running RAC. This has gone well, up to the point where, using clsetup, I attempt to create the rac-framework-rg (and associated rac-udlm-rs, rac-framework-rs). In attempting to create the resource group, the rac-udlm-rs fails to come online, causing the rest of the framework to fail. 

The error in the log file for UDLM (/var/cluster/ucmm/dlm_<zone>/logs/dlm.log is: 

CONNECT ERROR: 'Invalid argument', family=0, port= 6009, in=0.0.0.0 

This repeats 5 times per second on both zone cluster nodes. regularly the error changes port (i.e. it cycles through the ports). I've tried rebuilding the zone cluster, to no avail. I am at a loss as to what the error might be, or where to start looking, since there is no evidence anyone has ever hit this error before. 

Possibly related, or even the cause, is that the zone cluster has been configured with: add net  address=xxx.xxx.xxx.xxxend at the zonecluster level, but these addresses are not showing up under 'ifconfig -a'. how they are used, and when they should show up though. Some notes:the zone cluster in all other respects seems fine - I have QFS resources configured and these appear to successfully work in all circumstances.the ORCLudlm package is installed (the one that comes with Oracle 11.2.0.3)

View 2 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 :: 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

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 :: 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 :: 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 :: 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 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

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

Application Express :: Allow Only Specific APEX App Through Oracle Http Server

Aug 1, 2012

I'm having some difficulty securing my Oracle APEX + Oracle HTTP Server environment.

There are currently around 20 Applications running on the APEX Server, and I'd like to publish 2 of them Externally for users.

I have added a certificate to Oracle Wallet Manager to secure the OHS, but I can access all the Applications on the APEX Server by just changing the Application ID suffix.

How can allow only two applications to be accessible via the internet?

View 11 Replies View Related

Application Express :: Determining Oracle Version From Shared Component

Mar 25, 2013

How can I determine version of oracle database from APEX. Is there any built in table or view is available in APEX? Is it possible from Shared Component?

View 5 Replies View Related

Application Express :: Connect To External System Using Oracle APEX?

Jun 21, 2012

While browsing through the APEX, just wondering if there is any way to connect external database.

Like i have database connection string/user/password and service.

Is there any way to define these information in APEX to connect with external database?

View 5 Replies View Related

Application Express :: Oracle Document For Apex Applications Backups?

Sep 26, 2012

Is there any official document from Oracle which tells us how to export apex applications from command line instead of using the GUI from within apex ?

When I googled I saw some links from apex users who had written as how to export using ApexExport utilities, but since we are in windows environment, we are having hard time getting the class_path,java_home...etc setup properly. I guess its not just me most of them would have encountered it.

But I am looking for an official document from Oracle ? ( exporting Apex applications from command line in Windows Environment ).

View 4 Replies View Related

Application Express :: Access Oracle EBS Environment With Developer-level?

Jan 12, 2013

how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?

View 1 Replies View Related

Application Express :: How To Use Oracle SQL Developer To Connect To APEX Account

Oct 31, 2013

I have registered an APEX (Oracle) online database and I can connect to database online.But my problem is how to define a connection string that can connect from the program written in C# to connect to APEX account(apex.oracle.com).I even don't know how to use the tool Oracle SQL Developer to connect to APEX account.

View 3 Replies View Related

Application Express :: What Would Cause Oracle To Insert Duplicate Rows Into A Table

May 2, 2013

What would cause Oracle to insert duplicate rows into a table? Could a join of two tables in the initial query assigned to an application page cause ORacle to insert an extra row into a table when an update to data value occurs? I have no insert triggers and no foreign keys assigned to the table. I am not sure what would cause Oracle to assume that an insert of a row must occur. I want to prevent that insert.

View 9 Replies View Related

Application Express :: Installation Of Oracle Developer 4.1 - Cannot See Administration Page

Sep 12, 2012

I am trying to install oracle developer days 4.1 to test the oracle apex 4.1. When I load the .ovf image into virtual box and launch it, I go to

[URL]........

but I cannot see the administration page, it doesn't show me anything. Is there any installations that I have to do or missed to make apex work ?

View 5 Replies View Related

Application Express :: Upgrade Within Oracle XE Database Installation On Windows 7

Aug 28, 2012

O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============

Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.

It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.

View 2 Replies View Related







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