Upper-case double quoted objectnames

This script might come in handy if you also didn’t want the free double quoted upper-case object names in the object scripts on the DB, which you get importing and exporting a schema.

The script goes trough the user_source view and reconstructs a file with scripts to create or replace your current objects (packages, types, [...]

ApEx function wwv_flow.accept giving a 'page not found'

One of the applications I’ve build had the weirdest bug:
when navigating through the application the wwv_flow.accept sometimes gave a ‘page not found’ error.
I also had the error while developing the application navigating through apex itself.

The apache log showed:
mod_plsql: /pls/toolsdb/wwv_flow.accept HTTP-404 ORA-06550: line 22, column 3:\nPLS-00306: wrong number or types of arguments in call to ‘ACCEPT’\nORA-06550: [...]