|
|
|
|
| Re: PL/SQL Cartridge [message #234873 is a reply to message #234684] |
Thu, 03 May 2007 06:46   |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
