Re: CREATE/TRUNCATE in PL/SQL???
From: <tyld_at_detroitedison.com>
Date: 1996/07/02
Message-ID: <4rb16v$rk8_at_news.deco.com>#1/1
Date: 1996/07/02
Message-ID: <4rb16v$rk8_at_news.deco.com>#1/1
When you pass in the name of the table that you will using in your SQL statement, I believe this requires dynamic SQL. I don't think static SQL will work. I've seen this done using dbms_sql.open_cursor, dbms_sql.parse, dbms_sql.execute and dbms_sql.close_cursor. Check your reference manuals and give it a try.
David Tyl Received on Tue Jul 02 1996 - 00:00:00 CEST