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 →]

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 →]

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 →]

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 →]

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 →]

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 →]

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 →]

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 →]