Quantcast
OracleBrains.Com header image 5

Entries Tagged as 'Application Express'

Oracle Application Express Release 4.0 is released :)

June 27th, 2010 · No Comments

Oracle Application Express Release 4.0 was released on June 23, 2010 …but I got to know on train just now while going from Melbourn to Warrnambool..excited and getting eager to check it out.. Little slow on Oracle Forms 11g research…as busy with project of mine….

[Read more →]

Tags: Application Express

Application Express :: Copying Application Items from one application to another.

September 26th, 2009 · 1 Comment

Today while working on Oracle Application Express, I came across a situation, where I need to define same variables (Application Items) in another 2-3 different applications. Moreover these application may or may not be residing in same Workspace. I could have created the item manually across all the applications, but being a programmer brain plus [...]

[Read more →]

Tags: Application Express · Development Tools

ORA-20001 error in Application Express 3.2.0.00.27 with Oracle Database 11g release 1 (11.1)

March 11th, 2009 · 1 Comment

ORA-20001 is a most common error that occur when we first configure Application Express for PDF/report printing. Error is displayed as follows: ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified. Actually this happens due to security related enhancement done in [...]

[Read more →]

Tags: Application Express · Development Tools

SQL Command problem in Application Express 3.2.0.00.27

March 6th, 2009 · 1 Comment

Yesterday I installed Oracle Application Express 3.2.0.00.27. While doing my r&d, I came across one problem in SQL Command. For example I wanted to run sql “select * from tab” When I checked “Autocommit” checkbox, it worked fine as follows: But when I unchecked the “Autocommit” checkbox it gave me following error: ORA-01003: no statement parsed

[Read more →]

Tags: Application Express · Development Tools

Oracle Application Express 3.2 New Features!!!

February 16th, 2009 · No Comments

At last new release of Oracle Application Express 3.2 seem to be near! Oracle hasn’t made it available for download, but they have made it available in their hosted development site. Get details on feature notes here

[Read more →]

Tags: Application Express · Development Tools

Changing the password of internal ADMIN account in Application Express 3.1

March 10th, 2008 · No Comments

Now in Application Express 3.1 installation we have two scripts to change the password of internal ADMIN account. First one is as follows which was available before version  3.1 @UNZIP_DIR/apex/apxxepwd.sql password Where password is the password of the Application Express internal ADMIN account. Second one is as follows which is new in version 3.1 @UNZIP_DIR/apex/apxchpwd.sql [...]

[Read more →]

Tags: Application Express

Upgrading to Application Express 3.1 in your Oracle Database XE

March 10th, 2008 · 1 Comment

Even though there is a document about up-gradation at Oracle, I wrote what I thought I will be following in future. There are things which one may not find in documents but learn with experience or when actually doing it. Steps to up-gradation are as follows: 1. Change your working directory to apex where you [...]

[Read more →]

Tags: Application Express

Changing the password of Application Express internal ADMIN account

February 27th, 2008 · No Comments

Recently I forget the Application Express (version 3.0.1) internal ADMIN account of my development site. So to change the password without knowing the old password, I login as SYS into the Database Server and run the following script. SQLPLUS> @C:\oraclexe\apex\apxxepwd.sql new_password Where “C:\oraclexe\apex” is APEX_HOME directory. What this script is doing is as follows: First [...]

[Read more →]

Tags: Application Express