Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1047096368 bytes)
What I don't understand is why so much memory is being used. This is a test record that contains only 50 characters yet it is somehow trying to allocate several gigabytes of data.
I'm running this as a php application connecting to a db2 9.7 database. I am very new working with db2. My experience has been mainly with mysql. Here is the code that is giving the error:
Expand|Select|Wrap|Line Numbers
- $sql = "SELECT * FROM callresp where crprojid = 204547";
- $r = odbc_exec($conn, $sql);
- if(!$r){exit("Error in SQL");}
- while(odbc_fetch_row($r))
- {
- $desc = odbc_result($r, 'crDesc');
- $assigned = odbc_result($r, 'crAssigned');
- $problem = odbc_result($r, 'crProblem');
- $solution = odbc_result($r, 'crSolution');
- }