Create Table with DBMS_SQL problem

Hello,

I have a need to do a CREATE TABLE within a stored procedure in Oracle 8. I did some research and found the DBMS_SQL package and have been able to put together the dynamic SQL for my table creation. Problem is, when I need to access the newly created temporary table from a query in another part of the stored procedure, it can't find the table. At compile time I get a message saying that the table name is not a declared object.

It makes sense that at compile time there is no way to resolve the non-existant table. So, I'm guessing that I'm doing something wrong. How can I get the proc to compile and use my temp table? Is there another way to use temp tables from within a stored proc?

Thanks in advance for any advice.

Rob
rbell1_at_nospam@netscape.net Received on Thu Jun 24 1999 - 22:26:23 CDT