mORMot Open Source

peak.tibor

Member

Registered: 2013-02-22

Posts: 19

ORACLE OCI params count limit

I found the following limit for number of params:

function TSQLDBStatementWithParams.CheckParam(Param: Integer;
  NewType: TSQLDBFieldType; IO: TSQLDBParamInOutType): PSQLDBParam;
begin
  if self=nil then
    raise ESQLDBException.Create('Invalid Bind*() call');
  if (Param<=0) or (Param>64) then
    raise ESQLDBException.CreateFmt('Bind*(%d) should be 1..64',[Param]);
  if Param>fParamCount then
    fParam.Count := Param; // resize fParams[] dynamic array if necessary
  result := @fParams[Param-1];
  result^.VType := NewType;
  result^.VInOut := IO;
end;

As I know ORACLE itself does not have this max 64 param count limit.

I would need more.
Can I simple change '64' in the source to a greater number?

Thanks,

Tibor

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,666

Website

Re: ORACLE OCI params count limit

I've fixed this unnecessary limitation to 64 params for TSQLDBStatementWithParams.

See http://synopse.info/fossil/info/d6771c6bf1

Thanks for the report.

peak.tibor

Member

Registered: 2013-02-22

Posts: 19

Re: ORACLE OCI params count limit

Thans a lot.

Tibor