out of memory error running sql statement
843854Jan 9 2003 — edited Jan 14 2003I have a small application to accept a sql select statement from the user
and return the results. (I am using Oracle Type 4 driver with Oracle 8i
server).
I test it with the following query:
select * from policy_table where policy_number = 123456
The query works fine when the policy_table contains about a 1000 rows or so.
When I try the same query in a database that contains 80,000-odd rows for
this table, I get an out of memory exception.
I dont understand why does this error arises with the larger table since in
both cases the query is supposed to return only one row. What can I do to
get around this?
Thanks.