create or replace procedure "XXX"
is
CURSOR x IS
     SELECT id, code, name FROM table_a;
begin
FOR z IN x LOOP
BEGIN
     INSERT INTO table_b (ID, AID, CODE, NAME)
     VALUES
     ('', z.id, z.code, z.name);
END;
END LOOP;
end;

BEGIN XXX END;

/*
* Digest.java
*
* Created on 16 ตุลาคม 2550, 12:17 น.
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

package com.etc.util;

import java.io.UnsupportedEncodingException;
import java.nio.charset.Charset;
import java.security.InvalidKeyException;
import java.security.NoSuchAlgorithmException;
import javax.crypto.BadPaddingException;
import javax.crypto.Cipher;
import javax.crypto.IllegalBlockSizeException;
import javax.crypto.NoSuchPaddingException;
import javax.crypto.spec.SecretKeySpec;
import org.apache.log4j.Logger;

/**
*
* @author MaGicBank
*/
public class Digest {
    
    public static Logger log4j = Logger.getLogger(Digest.class);
    
    private static final String key = "XXXXXXXXXXXXXXXX";
    
    public static String encode(char[] input) {
        return Digest.encode(new String(input));
    }

    public static String encode(String input) {
        Cipher codec = null;
        byte[] preout = null;
        try {
            codec = Cipher.getInstance("AES");
            codec.init(Cipher.ENCRYPT_MODE, new SecretKeySpec(key.getBytes(Charset.forName("UTF-8")), "AES"));
            preout = codec.doFinal(input.getBytes("UTF-8"));
        } catch (NoSuchAlgorithmException ex) {
            log4j.fatal(ex);
        } catch (NoSuchPaddingException ex) {
            log4j.fatal(ex);
        } catch (InvalidKeyException ex) {
            log4j.fatal(ex);
        } catch (IllegalBlockSizeException ex) {
            log4j.fatal(ex);
        } catch (BadPaddingException ex) {
            log4j.fatal(ex);
        } catch (UnsupportedEncodingException ex) {
            log4j.fatal(ex);
        }
        return Digest.hex(preout);
    }
    
    public static String hex(byte[] buffer) {
        String dict = "0123456789ABCDEF";
        char[] out = new char[buffer.length * 2];
        for(int i = 0, j = 0; i < buffer.length; i++) {
            out[j++] = dict.charAt((buffer[i] >> 4) & 0x0F);
            out[j++] = dict.charAt(buffer[i] & 0x0F);
        }
        return new String(out).toUpperCase();
    }
    
}

private static final String key = "XXXXXXXXXXXXXXXX";

String cipher = Digest.encode("password");