| EXECUTE_QUERY throws Disk I/O Error [message #321876] |
Wed, 21 May 2008 12:19  |
smadje
Messages: 3
Registered: May 2008
Location: US
|
Junior Member |
|
|
Hello Martin,
EXECUTE_QUERY is not able to fetch more than 100,000 records from the table, it throws the disk I/O error on temporary record buffer file. The temp file goes more than 2GB. Do we have any alternative solution?
The code that we execute is as follows
GO_BLOCK('OBJECT');
SET_BLOCK_PROPERTY('OBJECT',default_where,'PROCESS_CODE = ''' || :control.process_code || '''');
EXECUTE_QUERY;
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
