cannot insert clob in 7.0.2
Posted: Mon 19 Jun 2017 10:10
Hi,
using unidac 7.0.2, direct mode, c++ builder xe10 seattle, vcl win32.
My computer is win10x64.
I have an oracle table (server is 12c SE2) :
(dtmess has a default value)
And I try to insert a row in it:
The insert works (no error) but clob is garbage. When I read it I get all question marks, instead of "<coucou></coucou>". It worked with unidac 6.xxxxxxxx. Any hint?
using unidac 7.0.2, direct mode, c++ builder xe10 seattle, vcl win32.
My computer is win10x64.
I have an oracle table (server is 12c SE2) :
Code: Select all
SQL> desc cec.messagesservice
Name Null? Type
----------------------------------------- -------- ----------------------------
DTMESS NOT NULL TIMESTAMP(6)
PRIORITY NOT NULL NUMBER(1)
MESSAGE NOT NULL CLOB
ID NOT NULL NUMBER(20)
STATUS VARCHAR2(20)
And I try to insert a row in it:
Code: Select all
...
int iSeq=200000, iPriority=5;
GDB->StartTransaction();
TUniSQL *qq=new TUniSQL(Application);
qq->Connection=GDB;
qq->SQL->Clear();
qq->SQL->Add("INSERT INTO MessagesService(priority, ID, message) VALUES (:1,:2,empty_clob()) returning message into :3");
qq->Prepare();
qq->SpecificOptions->Values["TemporaryLOBUpdate"] = "False";
qq->Params->Items[0]->AsInteger=iPriority;
qq->Params->Items[1]->AsInteger=iSeq;
qq->Params->Items[2]->DataType=ftOraClob;
qq->Params->Items[2]->ParamType=ptInput;
qq->Params->Items[2]->AsBlobRef->AsString = "<coucou></coucou>";
qq->Execute();
GDB->Commit();
delete qq;
...