Re: create table in a procedure

DottingTheNet wrote:

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

What you are trying to do will usually raise a red flag in the Oracle community. This is a practice used frequently with some other, MS SQL Server being the most frequently encountered, to circumvent consistency and serialization issues - the specific reasoning is not applicable in Oracle.

That having been said, you need to spend a bit of time in the PLSQL manual and, most definitely, in the Supplied PLSQL Procedures and Types manual - the latter actually being able to answer your question. These are available at http://docs.oracle.com

/Hans Received on Fri Apr 09 2004 - 00:12:47 CDT