Pl/sql getting row one by one

[Vidu Greg]

Hi

In my java class, I am connecting to a database and want to get a particular column (longblob type) from a particular table. I dont want to get all the rows in one time as I will get memory problem surely.
I want to get a row one by one, So can anyone please tell me how should I do that?

[Jeanne Boyarsky]

Originally posted by Vidu Greg:
I dont want to get all the rows in one time as I will get memory problem surely.

Have you tried it to know you get a memory problem? Sometimes we think there will be a problem and the driver optimizes for us. I'm sure you aren't processing by holding all the BLOBs in memory at once. That would clearly be a memory problem.

I want to get a row one by one,

If getting the default 10 or 20 records is too much memory you can call setFetchSize(1) to get one across the network at a time.