Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » PL/SQL Cartridge
PL/SQL Cartridge [message #234684] Wed, 02 May 2007 20:36 Go to next message
spooja
Messages: 25
Registered: May 2007
Junior Member
What is PL/SQL Cartridge?
Re: PL/SQL Cartridge [message #234723 is a reply to message #234684] Thu, 03 May 2007 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know if you'll find your answer there but it worths have a look:
http://www.oracle.com/pls/db102/print_hit_summary?search_string=PL%2FSQL+Cartridge

Regards
Michel
Re: PL/SQL Cartridge [message #234873 is a reply to message #234684] Thu, 03 May 2007 06:46 Go to previous messageGo to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
The Oracle Application Server PL/SQL cartridge is one of the techniques provided by Oracle to publish database-oriented content on the Web. It is based on PL/SQL, Oracle’s proprietary procedural language.
Re: PL/SQL Cartridge [message #234876 is a reply to message #234684] Thu, 03 May 2007 06:49 Go to previous message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
The PL/SQL cartridge has been the building block for the Oracle Application Server, it was the only “cartridge” in the Oracle Web Server version 2, which has evolved in Oracle Web Application Server version 3 and that we finally know as Oracle Application Server version 4. The main idea with the PL/SQL cartridge is that the request is mapped into a connection to a database where a procedure is called, the output of the procedure is returned to the navigator. The key component in the PL/SQL cartridge is the Database Access Descriptor, which is the reference of the Oracle account to be called. In the OAS configuration, a virtual path is mapped to a DAD. Default is that a commit operation is issued after the successful execution of the procedure.
The PL/SQL Web toolkit is made of a set of packages which provide procedures and functions to generate most of the HTML tags. For example htp.headOpen would generate <HEAD> and htp.title(‘Hello’) would generate <TITLE> Hello </TITLE>. All of these procedures write into a PL/SQL table that is transferred to the client at the end of the call.
Previous Topic: Maintaining CONSISTENCY AMONG USERS
Next Topic: How to install apex in my machine
Goto Forum:
  


Current Time: Fri Mar 29 06:39:33 CDT 2024