parameter passing via global temp table with unique name

From: toylet (
Date: 04/03/04

Date: Sat, 03 Apr 2004 23:13:51 +0800

Is there an easy to pass a result set (ie a table) from one stored
procedure to another via a uniquely named ##global_temp_table? Or is
there a better method?

The reason to use a uniquely named table is because the stored procedure
would be called by multiple parties. SO a fixed table name would cause
the callers to step on each other.

   .~.    Might, Courage, Vision. In Linux We Trust.
  / v \
/( _ )\  Linux 2.4.22-xfs
   ^ ^    11:08pm up 8 days 15:22 load average: 1.30 1.35 1.32

Relevant Pages