Indeed, if I put qry.Refresh after qry.RecordCount I can fetch all CLOB field fine. On free time I try to investigate why this happen.
Thanks to all for advices!
Search found 3 matches
- 24.03.2010, 09:59
- Forum: 6.6 - stable
- Topic: Problem with Oracle NCLOB fields
- Replies: 4
- Views: 640
- 19.03.2010, 15:13
- Forum: 6.6 - stable
- Topic: Problem with Oracle NCLOB fields
- Replies: 4
- Views: 640
Hi! Well, I alter NCLOB datatype to CLOB and now no more exception ORA-24806 raised, but following problem occuried: when I try to walk records with next code with qry do begin SQL.Text := 'select id, bindata from testlob'; Open; if RecordCount > 0 then begin for n := 0 to RecordCount - 1 do begin s...
- 16.03.2010, 10:02
- Forum: 6.6 - stable
- Topic: Problem with Oracle NCLOB fields
- Replies: 4
- Views: 640
Problem with Oracle NCLOB fields
Hi! I encounter problem to fetch binary data from Oracle fields with NCLOB datatype. For example, I have following table: CREATE TABLE testlob ( id INTEGER, name VARCHAR(50), bindata NCLOB ) I need to fetch id and bindata fields and I use TZQuery: qry := TZQuery.Create(nil); qry.Connection := ZConne...