tag:blogger.com,1999:blog-7235729615549403152024-03-16T06:40:07.039+05:30Ask AnanthaSome things about Oracle that I jot about, keep for my records. Some articles in this blog are not owned by me. They are for my reference only. Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.comBlogger236125tag:blogger.com,1999:blog-723572961554940315.post-81771679170911276602020-09-29T12:25:00.007+05:302020-09-29T12:26:24.778+05:30Your session has expired - For Custom Apps after Oracle Apex Upgrade from 5 to 20I was getting the above error "Your session has expired" immediately after upgrade of Oracle Apex from Version 5 to 20 in my premises. Searched a lot and did not find any resolution.
After trying to login in same browser, tried a private browsing mode in Chrome and Firefox. It logged in. That is when i realized that it might be due to session cache/cookie.
As a resolution I cleared all sessionAnantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-79824042908495259512019-04-01T12:45:00.000+05:302019-04-01T12:45:53.750+05:30Hierarchical Query with search parameters (Pruning)
The following is a query from a friend, Reproducing it here:
I have a menu structure using a hierarchical query. i have search field to enter some string and search.I should get the result in the same menu format with with the node and its parents.Can you please help me with the query for search ?eg.A1 A11 A12 A123 A13B1 B123C1 C11 C12If I search for %123% the result -A1 A12 Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-64002359449630772002017-11-13T11:58:00.003+05:302017-11-13T11:58:39.414+05:30Truth behind show user
SQLPLUS command line provides a show user help which can print which user you are logged in as. Just learned new today that it is not hitting the DB to get the results.
Tom, who else can bring it to light. I am just 12 years down the line to have read his message.
The content points to this article
The SQLPLUS caches the username as soon as a "connection" is established and saves it for reuseAnantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-73761333906140417672017-08-24T11:18:00.000+05:302017-08-24T11:18:08.972+05:30Reports Builder wont open in Windows 10 64bit - [SOLVED]
Though Oracle doesn't support Forms 10g in Windows 10: 64 bit, I had installed it and was working till last month. Then suddenly one fine day, the report builder window won't show up. Though it was running in the task bar, I couldnt do anything with it. Forms builder was working properly.
Then taking cue from this Oracle form community post, I copied the cauprefs.ora from my colleague. Boom, Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com12tag:blogger.com,1999:blog-723572961554940315.post-19723427765797825302017-06-14T16:19:00.002+05:302017-06-14T16:19:30.311+05:30Reuse and Show Apex's Wait Popup
Oracle Apex supports or offers a GIF image and an overlay while loading content using Dynamic Action/AJAX. While creating a dynamic action you have an option to select "Show Processing" for supported actions.
This shows a nice overlay over the screen and a GIF image out of the box. You may have scenarios to show a loading while doing some javascript/jquery actions on your own.
Will it not be Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-82156586981797756202016-10-24T11:14:00.001+05:302016-10-24T11:15:34.840+05:30Inserting DBMS_OUTPUT from wrapped procedures into a table
This tip is courtesy +V. Kapoor from http://www.foxinfotech.in. Thank you, you saved my day.
I had a situation where the database procedure SRW is wrapped and I needed to log the dbms_output.put_line output produced by the package into a table. Thanks to the tip provided, I was able to do so.
I had to call the following procedure
dbms_output.get_lines(vcol, n);
This procedure Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-36918716468830256282016-07-13T11:06:00.000+05:302016-07-13T11:06:37.183+05:30Opening Oracle Apex Links in iframe
Starting Oracle Apex 4.1, application pages by default will not open inside an iframe (inline frame).
There is a new security setting introduced, which is restricting this feature. As commented by +Patrick Wolf in community.oracle.com the following setting has to be changed to enable this feature:
This is what he had to say: "There is a new security feature to prevent Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-79586158591852948492016-05-11T23:17:00.000+05:302016-05-11T23:17:20.144+05:30Country State Dropdown dependency - AngularJS
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 Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-1181740420770841902016-01-13T18:47:00.002+05:302016-01-13T18:47:44.924+05:30[SOLVED] FRM-30401: Warning: Formula ignored for non-formula item
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 Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-74363208924070056282015-06-25T12:02:00.001+05:302015-06-25T12:04:44.648+05:30Oracle Apex: Dynamic Action Bug
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 (Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-88312030548822750092015-05-15T23:16:00.000+05:302015-05-15T23:16:27.477+05:30How to resize VirtualBox VMDK Hard disk size
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 Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-81870434800196762642015-04-17T13:11:00.001+05:302015-04-17T13:11:12.687+05:30Oracle Apex 5 - First impressions
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.
Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-12155629746800680522014-07-21T17:03:00.002+05:302014-07-22T12:48:49.681+05:30Get Image attributes from BLOB
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 &Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-9918614452746638942014-07-03T14:12:00.003+05:302014-07-03T14:12:55.174+05:30Learning Git
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 Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-56003411944711116772014-07-01T13:32:00.003+05:302014-07-02T21:37:43.793+05:30Save with PacktPub
Packt Publishing is celebrating 10 years of its presence by a unique promotional way.
To celebrate this huge milestone, from June 26th Packt is offering all of its eBooks and Videos at just $10 each for 10 days – this promotion covers every title and customers can stock up on as many copies as they like until July 5th. #Packt10Dollar
Hurry up, and buy your stocks before the Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-83491407013348722402014-06-27T12:50:00.001+05:302014-06-27T12:50:17.356+05:30ORA-00900: invalid SQL statement tips
I was getting this curious error lately in a development package. I could not resolve what could be the reason for this for sometime.
ORA-00900: invalid SQL statement
I got some head on from this website, but it did not help my case as both of the cases mentioned by him was not valid for me. I was not using any dblink or neither because of Y2K error.
I started to investigate upon it and with Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-34561618219382358412014-05-30T14:55:00.001+05:302014-05-30T14:55:24.715+05:30Custom CSV Download button for Interactive Report
Its a fact, users are lazy. They want to avoid multiple clicks of button. This time it is to avoid clicking on Actions Menu > Download > Click to download CSV. The requirement was to click one button, download the CSV.
Oracle Apex allows this using a simple technique. I was searching many blogs, OTN etc where people were asking you to create a new region, then change the settings of the Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-80591673654071208992014-05-27T12:22:00.003+05:302014-05-27T12:23:52.232+05:30Interactive Reports - Configure header and footers
Version: Oracle Application Express 4 and above.
Recently I had been asked by my colleague to how to configure header and footer for PDF printing of Interactive reports in Oracle Apex. We have been using Apex 4.2.5, but this tip will work for versions above 4.
If PDF download is not working in interactive reports in your setup, refer this article to configure PDF printing.
By default if you Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-2521377927714250592014-05-06T11:17:00.005+05:302014-05-06T11:17:55.578+05:30International day against DRM
Digital Rights Management (DRM) is a technique used by manufacturers or publishers to control use of their products after sale. If you buy a book, you are not allowed to copy the contents (even take a copy of a page you feel is important). Today on 6th May lot of organizations are raising a voice against the DRM.
As individuals it is our aim to support this voice, as we will be benefited. RaiseAnantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-72766779093535560092014-04-02T13:10:00.002+05:302014-04-02T13:10:41.119+05:30Book Review: Getting Started with Oracle VM VirtualBox
Getting Started with Oracle VM VirtualBox
This book gives a general introduction to Oracle VM VirtualBox software, which is used in virtualization. Using this software you will be able to run operating systems which are different from the one installed in your hard disk. It can be installed on your Mac, Linux, or even Windows machines. It adds the capability to run multiple operating system Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-61439941901598559122014-01-23T18:44:00.003+05:302014-01-23T18:45:06.922+05:30Oracle Query to get table size across schemas
I googled for this and got this from some website. Do not remember the website from where I got this query. Thanks for the original author. Pasting the query for my personal records:
SELECT owner,
table_name,
trunc(SUM(bytes) / 1024 / 1024) meg
FROM (SELECT segment_name table_name,
&Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-76115708384673536072014-01-06T13:34:00.002+05:302015-06-25T11:51:46.742+05:30jQuery tabs within Oracle APEX
This tip was posted in Oracle Apex Knowledge Group by Richard Martens. Its my sincere pleasure in thanking the author for this simple tip.
The original blog is available here. I am posting the steps first, and a slight deviation which makes the setup one time only through this article.
The idea is to create a region first and all sub-regions as tabs. If this design suits your application then Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-26880956889982560932014-01-02T15:59:00.002+05:302014-01-02T15:59:41.076+05:30Oracle APEX - Remove Show All from region selector
Oracle Application Express (APEX) offers a lot of regions to be displayed in a single page without cluttering the screen display. One such way of making a page to display lot of contents is using the Region Display Selector.
In this tip however I am not going to show how to display the "Region Display Selector" but an inherent problem with this control.
I have a screenshot of this control Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-36565247230670170722013-12-18T18:01:00.001+05:302013-12-23T19:00:37.230+05:30Are you Oracle database 12c ready?
I had recently attended OTN Database 12c Developer Day, at Bangalore. I must say it was very informative and gave me new insights on the new database unveiled recently by Oracle Corporation.
Rather than focussing more about the event, I will focus what was being the agenda or what what I learned from this event.
I must admit I am getting old because this cloud business is too hard to Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0tag:blogger.com,1999:blog-723572961554940315.post-40586433226465974112013-09-18T17:37:00.000+05:302013-09-18T17:37:00.988+05:30PDF Download not working in Interactive Report : Oracle APEX: SOLVED Finally
This was one of my biggest concerns while using Oracle APEX. I will often enable PDF download from Interactive Report setup in a page, but the download was generating only a corrupt file. My google searches also did not yield any result.
Then came the news that I have to install BI Publisher in order to use the feature. This message was floating in OTN forums related to this topic. I got Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.com0