SERIALLY_REUSABLE Pragma

The SERIALLY_REUSABLE pragma specifies that the package state is needed for only one call to the server (for example, an OCI call to the database or a stored procedure invocation through a database link). After this call, the storage for the package variables can be reused, reducing the memory overhead for long-running sessions.

This pragma is appropriate for packages that declare large temporary work areas that are used once in the same session.

The SERIALLY_REUSABLE pragma can appear in the declare_section of the specification of a bodiless package, or in both the specification and body of a package, but not in only the body of a package.

Topics

• Syntax

• Examples

• Related Topics

Syntax

serially_resuable_pragma ::=

Description of the illustration serially_reusable_pragma.gif

Examples

• Example 10-4, "Creating SERIALLY_REUSABLE Packages"

• Example 10-5, "Effect of SERIALLY_REUSABLE Pragma"

• Example 10-6, "Cursor in SERIALLY_REUSABLE Package Open at Call Boundary"

Related Topics

In this chapter:

• "AUTONOMOUS_TRANSACTION Pragma"

• "EXCEPTION_INIT Pragma"

• "INLINE Pragma"

• "RESTRICT_REFERENCES Pragma"

In other chapters:

• "SERIALLY_REUSABLE Packages"