CREATE OR REPLACE procedure SV.test_update2(action_code1 IN char)
 

 IS

 str_SQL varchar2(300);
      action_code   char(10):=action_code1;
      
  
    
      
BEGIN

          
       
    IF  action_code = 'SPLIT' then
        
        str_SQL := 'create table test_update_insert as
                    select * from test_update where accno is null';
                    
        DBMS_OUTPUT.PUT_LINE(str_SQL);
        
        Execute immediate str_SQL;
        
        str_SQL := 'create table test_update_delete as
                    select * from test_update where accno is not null';
        
        DBMS_OUTPUT.PUT_LINE(str_SQL);
        
        Execute immediate str_SQL;
        
        Commit;
           
    END IF;
    
    
    IF action_code = 'TRUNCAT' then
    
       
           str_SQL := 'truncate table test_update';
        
        DBMS_OUTPUT.PUT_LINE(str_SQL);
        
        Execute immediate str_SQL;
        
        commit;
        
   END IF;
   
   
   IF  action_code = 'REFRESH' then
   
        
        str_SQL := 'select * from test_update_insert into test_update';
        
                
        DBMS_OUTPUT.PUT_LINE (str_SQL);
        
        Execute immediate str_SQL;---->Getting error here(PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:)
        
              
        
   END IF;

   END test_update2;
/

orclz>
orclz> select * from test_update_insert into test_update;
select * from test_update_insert into test_update
                                 *
ERROR at line 1:
ORA-00933: SQL command not properly ended


orclz>