Oracle added a "procedural" component, otherwise know as PL/SQL, to the Oracle Relational Database Management System a long time ago. With a programming language in the database engine, application developers can work with database objects in their native form with significant improvements in efficiency and scalability.

I can not claim to know everything there is to know about PL/SQL and significant changes happen from version to version that make it even more difficult to keep up. This web log is my attempt to document some of the things I have learned over the years and to report on "new" (at least to me) discoveries as I come across them.

Feedback and suggestions are always appreciated. E-mail me at JohnJeunnette at PrairieSystemsGroup dot com.


The PL/SQL Web Toolkit
Keywords: PL/SQL Web Toolkit
It is only appropriate that I start this web log with some comments on the PL/SQL Web Toolkit. I have been using the toolkit for something like ten years now to create a number of database-based web applications. I still marvel at the simplicity and power of the concept of letting a browser-based HTML page communicate directly with the database, and vice-versa.

Some site examples include this web site content management application (Max), a technical conference abstract and registration processing application (CAAT at, a resource reservation tool (RRT at, and even a recipe storage site (ORB at

Operationally, the PL/SQL Web Toolkit is an Apache web server "mod", called mod_plsql, that takes HTTP requests from the browser and hands them off to a procedure in the database. The database procedure generates HTML and sends it back to the mod_plsql which returns the HTTP response to the browser. I'll expand on the use and abuse of the PL/SQL Web Toolkit in future columns.

Another area we will focus on is the collection of system packages that come with the database. PL/SQL code is the mechanism to operate the various options so we will spend some time on how to use the system packages.

Stay tuned for occasional thoughts.



Add a Comment:
  So we think you are a human,
please enter the sum of 9 and 2:

Other Entries:
July 2012
   7/31/2012:   UTL_FILE and BLOB data
March 2011
   3/14/2011:   ODTUG Tool Survey

Prairie Systems Group, Limited | Wind Point, Wisconsin, USA |
Copyright 2019, Prairie Systems Group, Limited