Corporation Server User Manual

mod_plsql

7-42 Oracle HTTP Server Administrator’s Guide

Notes:

■ Besides the patterns speciﬁed with this parameter, mod_plsql also disallows

any fully qualiﬁed procedure names which contain special characters like tabs,

newlines, carriage-returns, single-quotes, the reverse slash, the form feed, the

open parenthesis, close parenthesis, and space. This cannot be changed.

■ To add a pattern to the defaults, you must specify the default list with the

pattern you have added (as in the example in the table).

■ In older versions of the product, this parameter was called exclusion_list.

PlsqlFetchBufferSize Speciﬁes the number of rows of content to fetch from the

database for each trip, using either owa_util.get_page or owa_util.get_

page_raw.

By default, mod_plsql attempts to fetch 200 response lines of output where each

line is of 255 bytes. In situations where the response bytes are single-bytes, the

response buffer is populated to the maximum and can pack 255*200=51000 bytes for

each round trip. However, for responses containing multi-byte data, the byte

packing for each row could be less than ideal resulting in lesser bytes getting

transferred for each round trip. If your application generates large pages frequently

and the response does not ﬁt in one round trip, then consider setting this parameter

higher. However, the memory usage for mod_plsql will increase.

Example

PlsqlExclusionList sys.*

PlsqlExclusionList dbms_*

PlsqlExclusionList utl_*

PlsqlExclusionList owa_*

PlsqlExclusionList owa.*

PlsqlExclusionList htp.*

PlsqlExclusionList htf.*

PlsqlExclusionList myschema.private.*

The preceding conﬁguration excludes access to URLs containing sys.*,

dbms_*, utl_*, owa_*, owa.*, htp.*, htf.*, myschema.private.*

See Also: Oracle HTTP Server mod_plsql User’s Guide for more

information regarding security.

Category Value