Re: Mixing DDL & PL/SQL

I played around some more, and this works for me:

declare create_it varchar2(8);

begin
  create_it := 'yes';
  if upper(create_it)='YES' then
  execute immediate
  'CREATE TABLESPACE "test" LOGGING SEGMENT SPACE MANAGEMENT MANUAL    DATAFILE ''C:\ORACLE\ORADATA\TESTBED\test.dbf'' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 1500M';
  end if;
end;

Regards,
Nick Received on Mon Sep 26 2005 - 05:48:53 CDT