OO4O 3.2 and reading CLOBs

From: Dave Smith <scudderfish_at_my-dejanews.com>
Date: Mon, 15 Mar 1999 22:11:29 GMT
Message-ID: <7ck0i7$kru$1_at_nnrp1.dejanews.com>

Is it possible to use dynasets to read CLOBs? I have a table full of data, which I can view using SQL Plus, but when I execute the code below (or its C++ equivelent), my variant always comes back as NULL. The clob returns FALSE to IsNull, and reports a positive, correct, size. It makes no difference if I set a chunksize in the Read function or not.

Regards,
Dave

Dim sess As OraSession
Dim db As OraDatabase
Dim dyn As OraDynaset
Dim memo As OraClob
Dim var As Variant

Set sess = CreateObject("OracleInprocserver.XOraSession")

Set db = sess.OpenDatabase("snafu", "foo/bar", 0&) Set dyn = db.CreateDynaset("select * from testreco", 0)

dyn.MoveFirst
While Not dyn.EOF

    Debug.Print dyn.Fields("KEY").Value
    Set memo = dyn.Fields("MEMOFLD1").Value

    Debug.Print memo.IsNull, memo.Size
    Debug.Print memo.Read(var, memo.Size)
    Debug.Print var

    dyn.MoveNext
Wend

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 23:11:29 CET