Oracle Apex Notebook

ORA-01403 when viewing BLOB data in a report (APEX)

Written by Paulo Vale on Friday, October 31, 2008

This post is almost a note to myself but I hope to help others when you Google for this little problem.

One of the features introduced with Oracle Apex 3.1 is the Declarative BLOB support. About this subject there is already a good article on Oracle By Example (OBE) site: Defining and Viewing BLOB Data in Oracle Application Express 3.1.

Last Friday I lost almost an hour just to have a simple classic report with an image column. I was getting a ORA-01403 error because simply I wasn't referencing the Table Primary Key in my SQL Query!

<br /> report error:<br /> ORA-01403: no data found<br />

These are the steps needed to have the image column successfully displayed:

Report Source Query
Important Tip: You must include the Primary Key column in your query.

<br /> SELECT my_id, DBMS_LOB.getlength ("MY_LOGO") my_logo<br /> FROM my_table;<br />

Report Column Attributes

Format Mask Attributes
Important Tip: Database table and column names are case sensitive.

Tabular Form Element
Include the reference to the Schema, Table and Blob Column.

Oracle Develop 2008 Hands On Labs

Written by Paulo Vale on Friday, October 31, 2008

In case you have missed Oracle Open World 2008 and specifically the Oracle Develop Hands On Labs, this post is for you.

The Oracle by Example (OBE) is a site that provides hands-on, step-by-step instructions on how to implement various technology solutions to business problems. The tutorials presented at Oracle Develop 2008 Hands On Labs, part of Oracle OpenWorld 2008 are now available at OBE site.

Related to Oracle Application Express there are some interesting topics deserving some attention. Some tutorials are basic skills level but you will also find some advanced tutorials. I'm sure we can all learn something with them and that's why I made this list.


Under the topic "Extending the Oracle Application Express Framework with Web 2.0" you will find two excellent tutorials on how to incorporate JavaScript and AJAX into your Apex applications:

Incorporating JavaScript into your Application
Summary:
- Change the value of form elements
- Create client-side JavaScript validation
- Enable and disable form elements
- Hide and show form elements

Using AJAX into your Application
Summary:
- Add a dependent select list
- Set multiple items based on another item
- Add rollover item help


The topic "Creating High Fidelity PDF Reports with Oracle Application Express" takes Apex reporting to another level integrating Oracle BI Publisher functionalities:

Creating a PDF Report with Multiple Queries
Summary:
- Create a report query with multiple queries
- Create a report layout using Oracle BI Publisher Desktop
- Invoke a report from an application page

Including Dynamic Images in Your Report
Summary:
- Add and load a BLOB column
- Create a function that performs the BLOB to CLOB based 64 encoded format conversion
- Create a report query and layout
- Invoke the report from an application page

Storing and Accessing Reports in the Database
Summary:
- Create a table to store your reports
- Generate and store a report in the database
- Access the stored report in the database

Creating Reports With Dynamic Layout Selection
Summary:
- Produce multiple report layouts
- Create selection criteria items and processes for report generation
- Run a report dynamically


The topic "Maximizing the Capabilities of Oracle Application Express - Interactive Reports" is like a showcase on using and manipulating Interactive Reports in Oracle Application Express 3.1:

Using Interactive Report Regions
Summary
- View a record in your report
- Search for information in your report
- Manipulate the interactive report using the actions menu
- Manipulate the interactive report using column headers

Building and Customizing an Interactive Report
Summary
- Create an Application with an interactive report
- Manipulate and customize your interactive report

Utilizing Advanced Interactive Report Region Techniques
Summary
- Reset your Interactive Report Manually
- Create a declarative filter
- Create a derived predefined filter


The topic "Building a Functional Application Using Oracle Application Express 3.1" is appropriated to beginners and will show how you can rapidly create an application using Oracle Application Express:

Manipulating Database Objects
Summary
- Create a table
- Modify a table

Creating and Running an Application
Summary
- Create an application
- Edit Application Objects
- Create List of Values (LOVs)

Adding Additional Components to your Existing Application
Summary
- Add and modify a report, form, chart, and calendar
- Create LOVs and validation items
- Apply a new theme
- Update a navigation list

Adding Security to your Application
Summary
- Create a user
- Limit access to a user


Other interesting subjects, not directly about Apex, but somehow related and not to be missed:


Migrate Your Third-party Database to Oracle Database 11g Today
Migrating a Microsoft Access Database to Oracle Database 11g
Migrating a Microsoft SQL Server Database to Oracle Database 11g
Migrating a Sybase Database to Oracle Database 11g

Managing Your Database with Oracle SQL Developer
Managing your Database with Oracle SQL Developer - An Overview
Oracle SQL Developer 1.5 New Features
 
Source Code Control and User-defined Extensions in Oracle SQL Developer
Using Source Code Control in Oracle SQL Developer
Creating User-defined Extensions in Oracle SQL Developer

Oracle SQL Developer Data Modeling - Early Adopter Release

Written by Paulo Vale on Friday, October 10, 2008

The long waited Data Modeling functionality for Oracle SQL Developer is here. Oracle SQL Developer Data Modeling runs on Microsoft Windows XP and Vista, Linux and Mac OS X.

This is a first Early Adopter release, not a final product and I'm sure that the team behind the development, would appreciate all the feedback we can give them.