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
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