Plsqlafterprocedure, Plsqlalwaysdescribeprocedure – Oracle B12255-01 User Manual
Page 98
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