Plsqlcgienvironmentlist – Oracle B12255-01 User Manual

Page 102

Advertising
background image

mod_plsql

7-32

Oracle HTTP Server Administrator’s Guide

Notes:

This parameter is relevant only of you are using procedures with array
parameters, and passing varying number of parameters to the procedure.

The default should be sufficient for most PL/SQL applications.

To see if this parameter needs to be changed, check the number of versions of a
SQL statement in the SQL area.

Consider using flexible parameter passing to reduce the problem.

In older versions of the product, this parameter was called bind_bucket_
widths

.

PlsqlCGIEnvironmentList

Specifies overrides and/or additions of CGI

environment variables to the default set of environment variables passed down to a
PL/SQL procedure. This is a multi-line directive of name-value pairs to be added,
overridden or removed. You can only specify one environment variable for each
directive.

You can add CGI environment variables from the Oracle HTTP Server environment
by specifying the variable name. To remove a CGI environment variable, set it equal
to nothing. To add your own name-value pair, use the syntax myname=myvalue.

Category

Value

Syntax

PlsqlBindBucketWidths number multiline

Default

32,128,1450,2048,4000

Example

PlsqlBindBucketWidths 40

PlsqlBindBucketWidths 400

PlsqlBindBucketWidths 2000

Advertising