DSN8.CREATE_DGTT stored procedure
The DSN8.CREATE_DGTT sample procedure creates a declared temporary table named SESSION.DBMS_BUFFER.
SESSION.DBMS_BUFFER is used by the sample trace procedures.
Environment
The CREATE_DGTT stored procedure must be called from within a native SQL routine.
Authorization
To execute the CALL statement, the owner of the package or plan that contains the CALL statement must have one or more of the following privileges:
- The EXECUTE privilege on the DSN8.CREATE_DGTT stored procedure
- Ownership of the stored procedure
- SYSADM authority
Syntax
Notes
- Creation of this procedure:
- Sample job DSNTEJTR creates this procedure.
Examples
Example: Create the SESSION.DBMS_BUFFER declared temporary table.
CALL DSN8.CREATE_DGTT;