Re: Stored procedure

From: Sean Zhang <sean_at_cnfei.com>
Date: Tue, 22 Aug 2000 15:15:12 -0400
Message-ID: <orAo5.1658$N2.5993@firenze>

Yes,

Depents which Oracle version you have, if Oracle 8i:
you can put something like this in your PL/SQL code: execute immediate ' create table mytable( id number, name varchar2(20)...)' ;
Prior to Oracle 8i, you need to use

DBMS_SQL ( see Oracle Application deveoper's guide).

sean zhang

<sree_ls_at_my-deja.com> wrote in message news:8nufj5$md$1_at_nnrp1.deja.com...
> Hi,
>
> I want to know whether i can create a table inside a stored procedure
> ???
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 22 2000 - 14:15:12 CDT