Re: create table in a procedure
Date: Fri, 09 Apr 2004 05:12:47 GMT
Message-ID: <jhqdc.23972$J56.6584_at_edtnps89>
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 - 07:12:47 CEST