Using AddParam

[Matteo]

Hello everyone.

I'm using a TOraStoredProc but I dont understand how to use the TOraStoredProc .Params.AddParam() function.

Could someone post an example?


Tnaks in advance,

Matteo

[Challenger]

Perhaps you have a stored procedure with one parameter of type string. You can use the following code:

Code: Select all

var
  OraParam: TOraParam;
begin
  OraParam := TOraParam.Create(nil);
  OraParam.Name := 'id';
  OraParam.DataType := ftString;
  Oraparam.AsString := '1234567890';
  OraStoredProc1.Params.AddParam(OraParam);
  OraStoredProc1.Execute;
end;