Re: SQL server temporary tables to oracle cursors

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 5 Apr 2002 05:46:50 -0800
Message-ID: <39206c8b.0204050546.5fb88d47@posting.google.com>

Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<a6tk7n02t0u_at_drn.newsguy.com>...
> >From Oracle's point of view, this table needs to exist before a stored
> >procedure using it can compile. What I don't like is that when the
> >sensible step of cleaning up the garbage (dropping the temporary
> >table) is taken, the package and procedures become a non-functional
> >piece of junk.
>
> that "sensible step" is only "sensible" in SQLServer. It is not "sensible" in
> Oracle.

Thanks all for your replies. The temporary tables will be temporary no longer. I will no longer regard them as part of the import process, but as part of the database. I'll consider a separate schema for dirty records as Daniel suggests.

Jon Received on Fri Apr 05 2002 - 07:46:50 CST