parameter passing via global temp table with unique name

From: toylet (toylet_at_mail.hongkong.com)
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 \   http://www.linux-sxs.org
/( _ )\  Linux 2.4.22-xfs
   ^ ^    11:08pm up 8 days 15:22 load average: 1.30 1.35 1.32