From: forbrich@yahoo.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)