parameter passing via global temp table with unique name
From: toylet (toylet_at_mail.hongkong.com)
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