Re: PL/SQL Problem

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/09/29
Message-ID: <342F8F69.75CE@gatwick.geco-prakla.slb.com>#1/1

> What version are you using that allows CREATE TABLE and DROP TABLE?
>

It never has and as far as I know never will

> I have heard there is a package function DBMS_CMD that may allow such
> activity, but have never tried that. Do not even know the syntax for
> calling it.

The package you want is dbms_sql. Something along the lines of

declare
crtab intger := dbms_sql.open_cursor;

begin
dbms._sql.parse(crtab,'create table ......... ',dbms_sql.native'); end;

is what you are looking for.

Cheers,

Ian Received on Mon Sep 29 1997 - 00:00:00 CDT