Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure and table creation
If you create tables using dynamic sql it is quite obvious you also need to manipulate them using dynamic sql.
You don't have to use dynamic sql for all selects, you have to get some training. Databases are about design and structure, not about just rambling away and see what happens. And Oracle definitely is not a product that can be mastered without reading manuals.
Regards,
Sybrand Bakker, Oracle DBA
<orauser_at_my-deja.com> wrote in message news:8i9qrl$6i0$1_at_nnrp1.deja.com...
> How do I code a stored procedure which needs to create tables
> in it (temporary tables required for processing).
>
> If I code the create table within an 'execute immediate', the
> tables do not exist at compile time, and the procedure does not
> compile.
>
> If I create the tables, compile the procedure, and then drop the
> tables so they can get recreated at runtime, the procedure is
> invalidated.
>
> What is the right way to do this? Also, do I have to use
> execute immediate for all sql execution? Or can I do selects,
> inserts and updates directly without the 'execute immediate'?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 15 2000 - 00:00:00 CDT