Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create table in side a pl/sql sub program

Re: create table in side a pl/sql sub program

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Wed, 10 Nov 1999 01:03:24 GMT
Message-ID: <3828C46A.816CDF27@rationalconcepts.com>

You are trying to execute a data definition statement which cannot be executed statically in PL/SQL. Use dynamic sql to accomplish the create table statement.
See docs on dynamic sql.

hope that helps,
cindy

Nandakumar wrote:

> hi
>
> what is wrong with the foll. snippet of code?
>
> begin
> create table xxx_test (v1 number) ;
> end;
>
> any clue??
>
> Thanks
> --
> Nandakumar
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 09 1999 - 19:03:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US