Re: insert clob into table

mwojtow wrote:
> I have got table with many fields - including clob. And I would like to
> put data using INSERT command from C++ using OCCI.
> example below (not working :()
>
> Clob clob(conn); //existing connection object
> string s("looooong string"); // assume that this string is 8k long
> int s_size=s.length();
> clob.setEmpty();
> string sql="INSERT INTO tbl (string_col, clob_col) VALUES (:1,:2)";
> stmt->setSQL(sql);
> stmt->setString(1,"aaaa");
> clob.write(s_size,(unsigned char *)s.c_str(),s_size);
> stmt->setClob(2,clob);
> stmt->executeUpdate();
>
> And this is not working.I get error
> ORA-22275: invalid LOB locator specified
> :(
> If I changed lines
>
> clob.write(s_size,(unsigned char *)s.c_str(),s_size);
> stmt->setClob(2,clob);
>
> to
>
> stmt->setString(2,s);
>
> clob field has only part of string s value :(
>
> primary key is timestamp field and is set to default TIMESTAMP_NOW so I
> cannot get it's value :(
>
> database is on another server then client I run so I prefer not to set
> primary key to client local timestamp which can be different from server
> one.
> I'm using Oracle 9i database and client.
> Please help!

You will have to first insert an empty clob. SELECT the clob descriptor column and then UPDATE the clob. Take a look at the occiclob.cpp sample here:

http://www.oracle.com/technology/sample_code/tech/occi/files/occi10gsamples.tar.gz

Rgds.
Amogh Received on Thu Mar 02 2006 - 07:58:23 CST