Plsqlafterprocedure, Plsqlalwaysdescribeprocedure – Oracle B12255-01 User Manual

Page 98

Advertising
background image

mod_plsql

7-28

Oracle HTTP Server Administrator’s Guide

PlsqlAfterProcedure

Specifies the procedure to be invoked after calling the

requested procedure. This enables you to put a hook point after the requested
procedure is called. This is useful in doing SQL*Traces/SQL Profiles while
debugging a problem with the requested procedure. This is also useful when you
want to ensure that a specific call be made after running every procedure.

Notes:

For all purposes, except for debugging, this parameter should be omitted. You
could use this parameter to stop SQL Trace/SQL Profiling.

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

PlsqlAlwaysDescribeProcedure

Specifies whether mod_plsql should describe a

procedure before trying to execute it. If this is set to “On”, then mod_plsql will
always describe a procedure before invoking it. Otherwise, mod_plsql will only
describe a procedure when its internal heuristics have interpreted a parameter type
incorrectly.

Notes:

For all purposes, except for debugging, you should leave this parameter set to
“Off”.

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

Category

Value

Syntax

PlsqlAfterProcedure string

Default

None

Example

PlsqlAfterProcedure portal.mypkg.myafterproc

Category

Value

Syntax

PlsqlAlwaysDescribeProcedure On/Off

Default

Off

Example

PlsqlAlwaysDescribeProcedure Off

Advertising