Re: Create Table with DBMS_SQL problem

Hi Rob,
  funny you should ask. I've been working on a stored proc to create tables. Please post your script so I can get a better idea of where it's gone south.
Cindy

Rob Bell wrote:

> 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:44:01 CDT