Guest User

Untitled

a guest
Nov 20th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. 'begin' + #13#10 +
  2. ' pkg_x.insert(md1 => :md1,' + #13#10 +
  3. ' md2 => :md2,' + #13#10 +
  4. ' cnt => :cnt);' + #13#10 +
  5. 'end;';
  6.  
  7. md1:= VarArrayCreate([0, 99], varVariant);
  8. md2 := VarArrayCreate([0, 99], varVariant);
  9. --------
  10. DeclareVariable('md1', otInteger);
  11. DimPLSQLTable('md1', 100, 0);
  12. DeclareVariable('md2 ', otInteger);
  13. DimPLSQLTable('md2 ', 100, 0);
  14. DeclareVariable('cnt', otInteger);
  15. SetVariable('cnt', 100);
  16. SetVariable('md1', md1);
  17. SetVariable('md2', md2);
  18. Execute;
  19.  
  20. SetLength(md1, 100);
  21. SetLength(md2, 100)
  22. -------------------;
  23. FDQuery.ParamByName('md1').DataType:= ftInteger;
  24. FDQuery.ParamByName('md2').DataType:= ftInteger;
  25.  
  26. FDQuery.ParamByName('cnt').AsInteger:= 100;
  27. FDQuery.Params.ArraySize:= 100;
  28. for I := 0 to 99 do
  29. begin
  30. FDQuery.ParamByName('md1').Values[I]:= md1[i];
  31. FDQuery.ParamByName('md2').Values[I]:= md2[i];
  32. end;
  33. FDQuery.Execute(FDQuery.Params.ArraySize);
Add Comment
Please, Sign In to add comment