A string Param was set to empty string after exe

[nschmied]

Hello,
I Opps I have found a bug.

I use a TOraQuery, (or TOraSQL it's the same bug) with this SQL

INSERT INTO PCS.PC_EXTRACT_XML(
'PC_ISSUES_ID,
'PC_TYPE_XML_ID,
'EXM_TABLENAME)
'VALUES(:PC_ISSUES_ID,
':PC_TYPE_XML_ID,
':EXM_TABLENAME)'

The two ID as a type DOUBLE and TABLENAME is String.
I set one time PC_ISSUES_ID and EXM_TABLENAME ,and in a loop "FOR" I set many time PC_TYPE_XML_ID.
Look code.

Code: Select all

  FQryInsAllNormal.ParamByName('EXM_TABLENAME').AsString := aTableName;

  nCnt := 0;
  while nCnt  0 then
    begin
      FQryInsAllNormal.ParamByName('PC_TYPE_XML_ID').AsFloat := nInsId;
      FQryInsAllNormal.Execute;
    end;
    Inc(nCnt);
  end;

After the first Execute the string param was set to empty string by ODAC but not the param PC_ISSUES_ID.

Why this ?

Thank,

PS, I use the last OADC 5.55.1.3022 in VCL.NET, Oracle 10g, with OCI call (Not Net).

[Alex]

We couldn't reproduce the problem.
Please send us complete sample to demonstrate it and include script to create server objects.
Send this message to ODAC support address.