This problem usually stems from converting a SQLServer stored proc to an
Oracle stored proc. I have yet to find a reason for creating temporary
tables on the fly. However, if you feel that you just gotta have it then
use a global temporary table. You create it once and use it as a temporary
table.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Hervé Ferreira" <admiral_freebee_at_hotmail.com> wrote in message
news:ca41e26c.0305020039.797e53c_at_posting.google.com...
> Hello,
>
> I want to create a table in a pl/sql procedure to store the output
> while I gather it, but i'm having trouble with creating a table in my
> procedure. How could i solve this?
Received on Fri May 02 2003 - 07:27:47 CDT
