Ask Anantha

Its been some time since I have written in this blog. Its mainly because of my work schedule. Cutting short personal note, let me introduce the problem. I have a plain HTML page which has two drop-down which is my interest in the article. The first one is Country, second one is Region/State. My requirement is to change the Regions when Country is selected/changed. I was trying to implementing this on my own, rather than trying to use features provided by AngularJS. Then with this stackoverflow thread, I was blown out. It was as simple as a filter clause in ng-options. I had never ever dreamed of anything simpler. Of course in my JSON, region data has a country id which made this approach simpler. Let me share my JSON. {     "states": [     {             "id": 1,             "code": "KAR",             "name": "Karnataka",           ...

This was a strange error which was daunting me for couple of hours today. The field name reported by Forms Builder had no formula attached to it. The property of all fields in the block was also same. But since this was a warning, I tend to ignore. But after some more time, bogged over with the unnecessary popup while creating FMX. Some googling gave me an answer that this was a Form Builder Bug. Then in no time, I got the solution from Oracle Forums.  Specify some dummy formula in the field which is reporting error, and later clearing the property to None and no Formula removed the warning thrown.  Recording for my reference.

I was struggling to find a fix for the problem. Only now I recognized it was a bug in Oracle APEX Version 4.2.3.00.08. The scenario: 1. I have two regions with Interactive & Classical Report 2. When a value is modified in select item in page, I need to refresh these reports. (Used dynamic action to refresh regions on page item change) 3. I used jQuery tabs for the reports ( instructions on how to created it is here ) 4. I modified the Template of the reports to "No Template" 5. The region refresh stopped working. I was assuming that the refresh did not work because of jQuery tabs. But later I realized that the "No Template" caused the bug. To fix this you may either create a new Template or use a region which has a template. I have used the "Borderless Region (no heading)" and the dynamic refresh works. Not sure about this being fixed in later versions of Apex.

This post is due to lack of clear instructions available where I searched for. These are notes which I used to perform a hard disk extension in Ubuntu host for a Windows Vista is guest/vm. Summary of steps: Step 1: Convert vmdk file to vdi (if you are using vmdk as hard drive) Step 2: Resize vdi file to required hard drive size Step 3: Convert the resized vdi file to a new vmdk file (so that the original file serves as backup) Step 4: Remove the attached vmdk file in vm and add the newly converted vmdk file. Step 5: If you are running a Windows OS which supports Disk Management > Extend Volume then the guest OS will recognize the size of extended hard disk. Step 6: Remove the original vmdk file if everything is fine. Steps and commands: The commands which I used are as follows: Step 1: Convert vmdk to vdi VBoxManage clonehd "WinVistaDev-disk2.vmdk" "cloned.vdi" --format vdi Step 2: Resize vdi file: VBoxManage modifyhd "cloned.vdi" --...

The new age Oracle Apex is here to download. Till 16th April it was only available as a preview in apex.oracle.com. Starting yesterday it is available for download. For the first time, first day first show I could download Apex from otn and install in my local Express Edition database. The installation was smooth only 3 steps. The upgradation steps are clearly mentioned in documentation here . Step 1: Download zip file from otn Step 2: Unzip in folder of your choice Step 3: Run the following command in sqlplus which is connected to sys @apexins.sql tablespace_apex tablespace_files tablespace_temp images As I had not created any tablespaces, I simply ran the following command: @apexins.sql SYSAUX SYSAUX TEMP /i/ Step 4: Login back after the previous step and execute following: @apxldimg.sql APEX_HOME APEX_HOME is the folder containing the unzipped downloaded files of apex. For example @apxldimg.sql c:\ Step 5: Complete upgrade by updating password: @apxchpwd.s...

Q: How can I obtain image attributes such as height, width, format from BLOB column? A: Using Oracle Multimedia ORDImage object type it is possible to get such attributes. Consider the following example: DECLARE   lv_blob                  BLOB;   unused_attributes        CLOB;   img_mimetype             VARCHAR2(32);   img_width                INTEGER;   img_height               INTEGER;   img_contentlength        INTEGER;   unused_fileformat        VARCHAR2(32);   unused_contentformat     VARCHAR2(32);   unused_compressionformat VARCHAR2(32); BEGIN   SELECT blob_content   INTO lv_blob   FROM mytable;   ordsys.ordimage.getproperties (lv_blob,             ...

Now-a-days if you search for any source code, this word is always there. "GIT". What is so special about it? Well check out the Wikipedia page to know about its history. I would like to borrow one sentence from Wikipedia though: Git was initially designed and developed by Linus Torvalds for Linux kernel development in 2005 The light bulbs glowed for the first time. I always fancied Linux and its kernel development, though I knew nothing about it. But this was the first time something near to the Linux kernel was available to me, and which could help me manage my source code. Although the learning was mandated for official reasons, I now fancy Git in "all and everything" which I code. Having said that what is the starting point? I implemented Git in my local development first. My aim was to have Git take backup of everything in my development folder. The starting point was this Git book . I summarize the tasks I was upto: Create a fresh project folder ...