Oracle APEX: Interactive Report "no data found" while adding attachments link

You must follow the exact steps to add link to attachments in BLOB column in Interactive Report/IR in Oracle APEX:

1. Table must have primary key (I could not make this work with ROWID in View), and it must be queried in the select statement for IR.
2. In query one column must fetch size of attachment. You may use dbms_lob.getlength(blobcolumn) function to fetch the size.
3. In the size column added provide format mast as BLOB and in Apex 4.2.2 "BLOB Column Attributes" section will come.
4. In "BLOB Column Attributes" you must specify at least two columns, BLOB column in "Column" and "Primary Key column 1". If you have composite primary key, you may specify "Primary Key column 2".
5. If you are saving the file name in table, you may also identify the column name in "Filename Column" field.

If you are getting "no data found" error in the region of Interactive report, do make sure that the first point mentioned above is adhered to. It is a must. Just learned this today, sharing with you all.

Sample Application - Table Tennis - Oracle Apex

For educational purposes I had created a sample application. This application is intended to be used within an organization where a table tennis tournament is taking place.

The requirements for the application were:

  1. There should be provision to create Team and Players (Only doubles tournament was conducted).
  2. Team & Players should be entered in Master-Detail format.
  3. Matches & Results data should be entered as a tabular format.
  4. Match Calendar should be shown.
  5. Reports like:
    1. Points tally
    2. Top 4 teams (who will qualify for semi-finals)
The completed application can be downloaded from this link. The E-R diagram for the application (generated out from SQL Developer can be found below).

To see more information on generating E-R diagram from SQL developer click here.

Creating E-R Diagram from SQL Developer

This is one of the most coolest feature I like about SQL Developer. I am using version 3.1.07 and this feature is available in this version.

SQL Developer requires just the DDL scripts that I use for installation for the product and it generates the E-R diagram within seconds.

Where is my Page Zero? - Oracle Apex

Till Apex 4.1 while creating a page you had an option for creating "Page Zero". This page type is a special master page to your application. If you add any element to this page, automatically the element will be displayed in all pages within your application.

LOVs based on fields in page - Oracle Apex

I was reading about features in Oracle APEX 4.1 in Patrick Wolf's Blog, and I wanted to try it out to see how easy or difficult it is to implement a Select list which dynamically changes based on a different value in the page.

I created a sample application with three tables:

  1. Country_Master - Stores country id and name
  2. State_Master - Stores country id, state id, and name
  3. Company_Master - references country id and state id to store company record.
My intention was to implement country select list and state select list in company master page. As soon as I select a country states belonging to the country should be refreshed in state select list.

The APEX feature used: "Cascading LOV Parent Item(s)"