Re: PL/SQL Catch*22?

From: Jerry Apfelbaum <japfelba_at_ican.ca>
Date: 1997/11/07
Message-ID: <3463D1FD.AF2F3F49@ican.ca>#1/1

Thanks. I'm not really having any trouble creating the table. The difficulty is in doing DML operations in PL/SQL when the table doesn't yet exist at compile time.

         ie:        CreateTable;
                    ManipulateDataInTable;
                    DropTable;

Even though the first part will create the table, it doesn't exist when the whole thing is compiled before running it. Therefore, references to the table in the 2nd part cause the whole thing to fail compilation.

Any further thoughts?

Authorised User wrote:
>
> TRy this, if it works...
>
> CREATE OR REPLACE PROCEDURE create_Table
> (
> create_table_in IN VARCHAR2
> )
> IS

 ....
> BEGIN

 ....
> END Create_Table;
 

-- 
=================================================
Jerry Apfelbaum           email: japfelba_at_ican.ca
Eastern Sun Group Inc.    phone:     416.240.9695 
Toronto, Canada

Received on Fri Nov 07 1997 - 00:00:00 CST