Documenting the tools in my toolbox.Documenting the tools in my toolbox.
Confined to home, I will post articles on various topics, mostly articles about tools in my toolbox that I am submtting to the open source community. {...}
Uncategorized
Initializing a connection from a connection poolInitializing a connection from a connection pool
Oracle may maintain state in a database connection that can cause difficult to diagnose problems. Packages may maintain state and context variables may be set. After obtaining a connection from a connection pool one should prepare the connection. An easy way to do this is to create the following procedure {...}
apex authentication authorization oracle security
Apex Security with Fine Grained Access ControlApex Security with Fine Grained Access Control
I just stumbled across this 13 year old paper I wrote about Apex Security. Written in latex as a markup language and covers: Apex, Oracle Fine Grained Access, Virtual Private Databases, authentication and authorization. {...}
oracle plsql
A logging facility for PL/SQLA logging facility for PL/SQL
Developers frequently use the Oracle dbms_output package to emit messages from their stored procedures. Logger is a package to replace dbms_output and utl_file for logging messages. Logger is: Simple to use log to flat file or dbms_output multiple messages levels configurable message filtering logging entries contain: timestamp calling procedure caliing {...}
Scroll Up
Blog WordPress Theme By ThemesEye