Re: how to create table using stored procedure?

From: Peter Falson <pfalson_at_mail.com>
Date: 2000/05/19
Message-ID: <8F39B2A69pfa_at_192.168.100.133>#1/1


lkw_at_axiomatique.com (lkw) wrote in <8g2is8$l51$1_at_clematis.singnet.com.sg>:

>Hi All,
>
>One stricky quetion:
>How to run a DDL commnand inside Stored Procedure?
>like create table .... ??
>
>Your helps would be greatly apprecitated.
>
>lkw.
>
>

I use a standard procedure called ANYDDL:

procedure anyddl (s1 varchar2) as
cursor1 integer;
begin
cursor1 := dbms_sql.open_cursor;
dbms_sql.parse(cursor1, s1, dbms_sql.v7); dbms_sql.close_cursor(cursor1);
end;

Then in any other procedure:

BEGIN
  ANYDDL('CREATE TABLE bla bla bla');
END; Received on Fri May 19 2000 - 00:00:00 CEST

Original text of this message