MattsBits
MattsBits - Brunel District

MattsBits

MattsBits RSS Feed - Subscribe Now!

A collection of techniques, code snippets and information relating to PLSQL, Javascript and APEX

RSS Feed for APEX category

Category : APEX

Categories : | APEX | Views : 165 | Email Link
The Interactive Reports in Oracle Application Express (APEX) are extremely useful. Sometimes you need to tweak their styling but there are limited ways to do that from the interface. So how can you do it?

The styling of an interactive report is set using the default stylesheet (something like apex_3_1.css).

Technorati Tags : | oracle | apex | interactive report | css |

Categories : | APEX | Views : 424 | Email Link
Within the APEX APEX_UTIL package there are a couple of useful procedures for setting and resetting Interactive Report filters. This allows you to manipulate IR filters programmatically within PLSQL.

For some reason these packages are not included in the official APEX API documentation so I have included some details below :

Technorati Tags : | apex |

Categories : | APEX | Views : 475 | Email Link
When you delete records from a record set in Oracle Application Express using a Delete button it is best to give the user a chance to cancel.

This can be easily achieved using a JavaScript popup confirmation dialog box.

Technorati Tags : | oracle | apex | javascript | delete | confirmation |

28/04/2009 : APEX URL Construction

Categories : | APEX | Views : 482 | Email Link
The Oracle Application Express URL contains a number of parameters. These parameters are documented but the summary below is quick guide to get you started.

A typical URL takes the form :

http://www.examplesite.com/pls/apex/f?p=1:2:3:4:5:6:7:8:9

Technorati Tags : | oracle | apex |

Categories : | APEX | Views : 370 | Email Link
In order to add debug messages to APEX pages you can use the following syntax :

wwv_flow.debug('This is my debug message');


You can use PLSQL variables or APEX page items :

wwv_flow.debug('### The value of P1_TEST_ITEM is ' || :P1_TEST_ITEM);


The three ###s make the debug message stand out from the numerous other APEX messages.

Technorati Tags : | oracle | apex | debug | plsql |

15/04/2009 : Send Emails From APEX

Categories : | APEX | Views : 631 | Email Link
In order to send emails from Oracle APEX you can use the APEX_MAIL API.

You can send plain text or HTML emails while defining the sender, recipients and bccs.

Note : The package is built using the Oracle supplied UTL_SMTP package so the UTL_SMTP package must be installed and functioning in order to use APEX_MAIL.

Technorati Tags : | oracle | apex | email | plsql |


No Previous Records No More Records


 
 
 
PHP Powered  MySQL Powered  Valid XHTML 1.0  Valid CSS  Firefox - Take Back The Web  EUKHost - Recommended Webhosting Solutions

MattHawkins CMS v2.0 - Copyright 2009-2010