Re: DDL in a PL/SQL block?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 5 Mar 2000 08:01:04 -0000
Message-ID: <952243831.22470.0.nnrp-10.9e984b29@news.demon.co.uk>

The method varies from version to version. With version 7 you need to use the package dbms_sql - there is a sample wrapper for it on my website

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

RoadRaat wrote in message <20000304194710.02650.00000111_at_ng-fh1.aol.com>...
>Is it not possible to put Data Definition Language in a PL/SQL block?
>
>I'm writing (what I thought would be a simple) PL/SQL program to loop
through
>all of my current tables and CREATE successive backups AS SELECTs.
>
Received on Sun Mar 05 2000 - 02:01:04 CST