Run the command script to the right.

You will now create a set of stored procedures and functions using the CGTT. This is not possible with DGTTs. This new support provided by CGTT allows for much more complicated tasks to be accomplished using a temporary table.

As you have seen in the last step, a DGTT definition does not persist between sessions. This means that a DGTT will need to be declared in each session before use. Furthermore, application objects such as Stored Procedures (SPs) and User Defined Functions (UDFs) cannot be created against a DGTT.

  Isolation Automatic cleanup Application Object Support Performance
Static Table
DGTT
CGTT

You should see successful statements in the lower right panel.