Re: create table in a procedure

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 09 Apr 2004 05:05:27 GMT
Message-ID: <raqdc.95912$gA5.1265540@attbi_s03>

"DottingTheNet" <dottingthenet_at_hotmail.com> wrote in message news:11bf8d5a.0404082019.6fbd8738_at_posting.google.com...
> help plz!!
> when i try to cretae a table in a procedure like
>
> create procedure blah
> is
> begin
> create table.....
> .....
> end;
>
> i get error PLS-00103 stating that it encountered CREATE when
> expecting everything else..
>
> thnx!!

This in general is a very bad idea. Why are you doing this? Are you from a SQLServer background? In Oracle it is very rare you would ever need to do this.

Jim Received on Fri Apr 09 2004 - 00:05:27 CDT