Create table or external table using Procedure

Hai,

     I want to create table or create external table using procedure. But, i am not able to do it. Here the code :

CREATE PROCEDURE TEST AS

BEGIN      
      CREATE TABLE CLS_TEST
      (
       DATE_EXTRACT CHAR(8),
       APPL_ID CHAR(3),
       ENTITY_NAME CHAR(3),
       BORRO_NAME CHAR(35),
       ROC CHAR(15),
       BORRO_TYPE_CODE CHAR(2),
       BORRO_TYPE_DESC CHAR(30),
       CUST_NUM CHAR(6)
      )
       ORGANIZATION EXTERNAL
        (
         TYPE ORACLE_LOADER
         DEFAULT DIRECTORY Source_dir
         ACCESS PARAMETERS
         (
               RECORDS DELIMITED BY NEWLINE
            BADFILE bad_dir:'CLS_TEST_BADFILE.txt'
            LOGFILE log_dir:'CLS_TEST_LOGFILE.txt'
            FIELDS
            (
             DATE_EXTRACT     POSITION(01:08),
              APPL_ID               POSITION(09:11),
              ENTITY_NAME         POSITION(12:14),
              BORRO_NAME         POSITION(15:49),
              ROC                     POSITION(50:64),
              BORRO_TYPE_CODE  POSITION(65:66),
              BORRO_TYPE_DESC  POSITION(67:96),
              CUST_NUM               POSITION(97:102)))
             LOCATION('CLSCUSTOMER.txt'));
      
       COMMIT;
END;


I try to compile the script using TOAD (Tools For Oracle Developer). But,
I having this error message :

PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:

   begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>

Can anybody help me to solve this problem.. I hope somebody can help me. ok




 Start Free Trial