Jquery AutoComplete for APEX 3.2

There are 4 steps involved.

1) Create region and textbox.
2) Download Jquery Plugin and upload it.
3) Enter the Javascript in HTML Header.
4) Make an application process. 

In Detail : 

1) Create region and textbox.

Create a Html region in a page. I have created as " Testing Autocomplete "
Add a new textfield for the Html region. I have created as "P71_USER_MAILID".
This is where autocomplete will be implemented.

2) Download Jquery Plugin and upload it.

I have downloaded jquery-ui-1.8.16.custom.zip.
I have uploaded 3 files : jquery-1.6.2.min.js, jquery-ui-1.8.16.custom.min.js and jquery-ui-1.8.16.custom.css

3) Enter the Javascript in HTML Header.

Enter the following code in HTML Header :

<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery-1.6.2.min.js"></script>
<script type="text/javascript" src="#WORKSPACE_IMAGES#jquery-ui-1.8.16.custom.min.js"></script>
<link rel="stylesheet" type="text/css" href="#WORKSPACE_IMAGES#jquery-ui-1.8.16.custom.css" />

<script type="text/javascript">

$(document).ready(function(){

   var ajaxRequest = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=getList',0);
   var ajaxResult = ajaxRequest.get();
   var newList=ajaxResult.split(",");
   $( "#P71_USER_MAILID" ).autocomplete({                       
            source: newList
        });
 });

</script>

4) Make an application process.

Create an application process with the same name as given in Javascript.
I have created with name "getList".
Make the Process point as On Demand : Run this application when requested by a page process.

  Declare
  lv_List varchar2(2000) := '';
  Begin
  Begin
    for i in (select USER_EMAILID from USER_TBL) loop
      lv_List := lv_List || i.USER_EMAILID;
       lv_List := lv_List ||', ';
    end loop;
    exception when no_data_found then null;
  End;
  htp.prn(lv_List);
End;

--------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------- 

Steps to Upgrade to Apex 4.0.2

V4 is as easy to upgrade as any previous version, however, V4 has a lot of new themes.

Download latest application express.

I have downloaded apex_4.0.2.zip.

Installing in Windows :  

Unzip the apex into c:\apex\  

 All the unzipped files will now be in C:\apex\apex

Open Command prompt. 

Change the directory to the location where the file apexins.sql is present(c:\apex\apex\apexins.sql).

Run SQLPLUS. 

Login as SYSDBA user.

Run the command - @apexins SYSAUX SYSAUX TEMP /i/

(as shown below)

After the above steps are done, the next step is to upload the images.

Open Command prompt again if it was closed previously.

Change the directory to the location where the file apxldimg.sql is present(c:\apex\apex\apxldimg.sql).

Once again run SQLPLUS and Login as SYSDBA user.

Move the new images in (the last parameter is the directory where you unzipped apex from, in this case apex) : @apxldimg.sql c:\apex

Last step,
You need to set the admin password : @apxxepwd.sql password


Now log into apex in a browser: http://127.0.0.1:8080/apex/apex_admin


User : admin
Passwd : password

 

You can change the admin password and check for all the users and add any new user in case you want to.

Now log into apex in a browser: http://127.0.0.1:8080/apex/

Thats it, Enjoy Apex 4.

Thanks for helping me set this up, Vishwa(my colleague). :)