oci8_result.php error

[eluser]phenom[/eluser]
I've got this problem when i run the controller

Code:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 48 bytes) in C:\xampp\htdocs\pmk120\system\database\drivers\oci8\oci8_result.php on line 155

This is my model

Code:

<?php
class tmasteru extends Model
{
    function __construct()
    {
        parent::Model();
    }
    
    function idle()
    {
        $sql = 'SELECT  b.urkpknl urkpknl,
                          a.kd_brg kdbrg,
                        b.urkpknl nmkpknl,
                        d.no_kib nokib,
                        d.surat1 jnspemilikan,
                        d.unit_pmk unitpemakai,
                        d.kd_kec kec,
                        d.kd_kab kdkab,
                        a.kuantitas luas,
                        a.tgl_perlh tglperl,
                        a.rph_aset biaya,
                        d.rphnjop njop,
                        d.status status
                FROM    t_masteru a,
                        t_kpknl   b,
                        t_sskel   c,
                        t_ktnh    d
                WHERE   a.kdkantor = b.kdkpknl    AND
                        a.kd_brg   = c.kd_brg   AND
                        a.kd_brg   = d.kd_brg   AND
                        a.no_aset  = d.no_aset  AND
                        d.status = \'HAK MILIK\'  OR
                        d.status = \'Hak Milik\'  OR
                        d.status = \'hak milik\'      
                        ';        
        $query = $this->db->query($sql);
        return $query->result;
    
    }
}

This is my controller

Code:

<?php
class Upk3101 extends Controller
{
    function __construct()
    {
        parent::Controller();    
    }
    
    function index()
    {
        $this->load->model('tmasteru');
        $query = $this->tmasteru->idle();
        $this->load->view('upk3101');
    }
}

and This is my view

Code:

<?php
    foreach ($query as $row)
    {
        print $row->urkpknl;
        print $row->kdbrg;
    }
?>

help me please...
sorry for my bad english

[eluser]phenom[/eluser]
when i restart my computer
then i run it again
this error message appear with different line

Code:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 42 bytes) in C:\xampp\htdocs\pmk120\system\database\drivers\oci8\oci8_result.php on line 220

[eluser]phenom[/eluser]
help me please

[eluser]kgill[/eluser]
http://lmgtfy.com/?q=php+Fatal+error:+Al...ry+size+of

The bigger question here is how much data are you pulling down in the result-set that you're eating through 32MB...

[eluser]phenom[/eluser]
so, the problem is the size of data that bigger than 32MB, isn't it?
sorry for my bad english