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.

John.

 
3/15/2010
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 www.technicalconferencesolutions.com), a resource reservation tool (RRT at www.resource-reservations.com), and even a recipe storage site (ORB at www.recipe-safe.com).

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.

 

Comments:

Add a Comment:
Author:
Text:
  So we think you are a human,
please enter the sum of 6 and 3:
 
 
 

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

 
Prairie Systems Group, Limited | Denver, Colorado | www.PrairieSystemsGroup.com
PLSQL_JOURNAL
Copyright 2009, Prairie Systems Group, Limited