Denes Kubicek ApEx BLOG

Tuesday, 19 March 2013

Select List with Dynamic LOV and ORA-06502: PL/SQL: numeric or value error: character string buffer too small

›
If you need to create a dynamic SQL for a select list or any other type of a LOV, your query should not exceed 4000 characters. In case it d...
6 comments:
Saturday, 16 March 2013

Formating and Exporting a Report Column

›
Sometimes you need to format a report column and if you need to do that in the report SQL, you will be faced with a problem while exporting...
Thursday, 14 March 2013

APEX Collections and Joins

›
APEX Collections is one of the best features of APEX. There are situations where solutions wouldn't be possible if this feature would no...
5 comments:
Wednesday, 13 March 2013

Upgrade to APEX 4.2.1.00.08 - First Impressions

›
Today one of my customers upgraded their APEX 4.0 to 4.2.1.00.08. The whole process was completed without any issues. After the upgrade ther...
Sunday, 3 March 2013

Reading a file from an URL and storinig it as a BLOB

›
In this example at apex.oracle.com you can se how you can use an URL (which normaly provides a save/download dialog for saving or opening ...
Thursday, 28 February 2013

Oracle and APEX

›
This is the text of an email I received as a response after creating an account for my workspace and my demo application at apex.oracle.com...
1 comment:
Monday, 18 February 2013

APEX Training 15.04. - 17.04.2013

›
Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir ( Dietmar Aust und ich) unser Oracle APEX: Knowhow aus der Praxis   Tra...
Saturday, 16 February 2013

Count Substring Occurrences in a String

›
If you write a lot of PL/SQL code, sooner or later you will be faced with a requirement to count the number of occurrences of a substring in...
6 comments:
Thursday, 14 February 2013

APEX Authentication Function

›
Did you know that an authentication function in APEX is not used the way a function actually should be used?   Normally, this function h...
Saturday, 1 December 2012

Dietmar Aust - Oracle ACE

›
It is now official - my friend Dietmar Aust is an Oracle ACE. C ongratulations . Well deserved.
2 comments:

APEX - Statement of Direction

›
The new Statement of Direction is touching a couple of interesting things. Here are the three most important: New Multi-Row Edit Region ...
Monday, 5 November 2012

Package for Creating Custom Code

›
Sometimes you will need to create your own processes for fetching values, validating and updating tables in a form. In some situations the w...
1 comment:
Friday, 26 October 2012

Goodbye apexblogs.info

›
http://www.apexblogs.info was a place I visited daily. A couple of days ago this domain was moved to http://www.odtug.com/apex . I am not s...
9 comments:
Sunday, 14 October 2012

APEX Reporting on Comment Columns

›
This function may help you if you need to report on columns with a lot of text. It will get rid of the carriage return and will help not to ...
Monday, 1 October 2012

My Demo Application

›
The link to My Demo Application on apex.oracle.com has been changed from http://apex.oracle.com/pls/otn/f?p=31517:1 to https://apex.or...
3 comments:
Sunday, 2 September 2012

APEX 4.2

›
Today, apex.oracle.com was updated to 4.2. My first impression was good - I haven't seen the early adopter this time. If you have an acc...
2 comments:
Sunday, 26 August 2012

Highlight Search Term

›
APEX can highlight the search string in a report if you enter the substitution string in the column property of your report - Highlight Word...
Sunday, 8 July 2012

Count Checked Rows in a Tabular Form

›
This is a quite simple but still frequently asked question. Here is an example on how to count checked rows in a tabular form. You may need ...
Thursday, 28 June 2012

Text Area with Character Counter in a Tabular Form

›
This small example shows how to create a textarea in a tabular form with a character counter, similar to the one for the page item of type ...

APEX Tabular Form and ORA-01403: no data found

›
If you get the "ORA-01403: no data found" error after running your code while updating or validating a tabular form, you will need...
9 comments:
‹
›
Home
View web version

About Me

My photo
Denes Kubicek
View my complete profile
Powered by Blogger.