Re: Create table problem using Dynamic Query

Ach C via DBMonster.com wrote:
> Hi all,
> I want to create a temporary table within a stored procedure so I decided to
> do it using a dynamic query:

I assume you are trying to kludge Oracle into being SQL Server: Don't.

A GTT is created once, and only once, when a schema is created along with it's heap tables. There is never a reason to create one in a stored procedure.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)