8. SQL Statements : EXECUTE PROCEDURE : Temporary Table Parameter
 
Share this page                  
Temporary Table Parameter
The temporary table must have been declared prior to procedure execution. However, it does not have to be populated (because the procedure itself can place rows into the table). Upon invocation of the procedure, Ingres binds the executing procedure unambiguously to the global temporary table instance of the invoking session. This permits any number of users, each with their own temporary table instance, to execute the procedure concurrently.
Example:
execute procedure gttproc (parm1 = session.mygtt1);
This statement invokes the procedure gttproc, passing the global temporary table session.mygtt1 as its parameter. (The name used for the actual parameter is inconsequential.)