#WEB BROWSER PASS VIEW DOWNLOAD#

This listener is the same server-side process as the Oracle Net Listener and supports Oracle Net Services, HTTP, and FTP.Д¬onfigure general HTTP listener settings through the XML DB interface (for instructions, see Oracle XML DB Developer's Guide). Unlike mod_plsql, the embedded gateway processes HTTP requests with the Oracle XML DB Listener. The XML DB HTTP Listener sends the page to the client browser. The embedded gateway sends the page to the XML DB HTTP Listener. The application sends the page to the embedded gateway. The PL/SQL subprogram generates an HTML page out of relational data and the PL/SQL Web Toolkit accessed from the database. The embedded gateway prepares the call parameters and invokes the PL/SQL subprogram in the application. The embedded gateway uses the HTTP request information and the gateway configuration to determine which database account to use for authentication. The XML DB HTTP Listener routes the request to the embedded PL/SQL gateway as specified in its virtual-path mapping configuration. The subprogram can either be written directly in PL/SQL or indirectly generated when a PL/SQL Server Page is uploaded to the database and compiled. The Oracle XML DB HTTP Listener receives a request from a client browser to request to invoke a PL/SQL subprogram. The explanation of the steps in Figure 9-2 is as follows:

#WEB BROWSER PASS VIEW DOWNLOAD#

Subprograms that download documents from a document repository that you define using the DAD configuration.ДЇigure 9-2 Processing Client Requests with Embedded PL/SQL GatewayДescription of 'Figure 9-2 Processing Client Requests with Embedded PL/SQL Gateway' Date values are simple strings in HTML, but must be properly treated as an Oracle Database data type. HTML utilities to retrieve the values of CGI environment variables and perform URL redirects.Дate utilities for correct date-handling. You can also use them directly.Дynamic SQL utilities to produce pages with dynamically generated SQL code. Subprograms used by package OWA_PATTERN for manipulating strings. Subprograms used by the PL/SQL gateway for authenticating requests. Subprograms that perform string matching and string manipulation with regular expressions. Lost updates can otherwise occur if a user selects, and then attempts to update, a row whose values were changed in the meantime by another user. Subprograms that impose database optimistic locking strategies to prevent lost updates. Use this package when you have an image map whose destination links invoke a PL/SQL gateway. Subprograms that obtain the coordinates where a user clicked an image. State can be maintained throughout a client session or longer if a cookie expiration date is included. Cookies are strings a browser uses to maintain state between HTTP calls. Subprograms that send and retrieve HTTP cookies to and from a client web browser. You can use this package to enable expires-based and validation-based caching with the PL/SQL gateway file system. Subprograms that enable the PL/SQL gateway cache feature to improve performance of your PL/SQL web application. Use these functions when you must nest function calls. Instead, they pass their output as return values to the statements that invoke them. The function versions do not directly generate output in a web page. Table 9-1 Commonly Used Packages in the PL/SQL Web Toolkit PackageДЇunction versions of the subprograms in the htp package. The embedded gateway does not support mod_plsql features such as dynamic HTML caching, system monitoring, and logging in the Common Log Format. You cannot use this configuration with the embedded gateway. You can run it in a firewall environment in which the Oracle HTTP Server runs on a firewall-facing host while the database is hosted behind a firewall. Some advantages of using mod_plsql over the embedded form of the PL/SQL gateway are: PL/SQL gateway translates the URL, invokes the stored subprogram with the parameters, and returns output (typically HTML) to the client. In this context, an HTTP request is a URL that includes parameter values to be passed to a stored subprogram. The mod_plsql plug-in enables you to use PL/SQL stored subprograms to process HTTP requests and generate responses. Oracle HTTP Server is a component of both Oracle Application Server and the database. The module is a plug-in of Oracle HTTP Server and enables web browsers to invoke PL/SQL stored subprograms. Mod_plsql is one implementation of the PL/SQL gateway.

Web browser pass view