[firebird-support] Stored Procedure with one input parameter on DataSnap Server returning table

[Franz]

Please help with specifying components and parameters for the following 
situation:

1. DataSnap Server with one table TestParm and one stored proc TestSP:
begin
  TestOutput = :testInput*10;
  TestBlob = :TestInput * 100;
  insert into TestParm (TestInput, TestOutput, TestBlob) values (:TestInput, 
:TestOutput, :testblob);

  for
    select TestInput, TestOutput, TestBlob
    from TestParm
    where TestParm.TestInput = :TestInput
    into :TestCopyInput, :TestCopyOutput, :TestBlob
  do
    begin
         suspend; 
    end
end

2. Delphi XE2 DataSnap Server with a  unit ServerMethodsUnit.pas with
TSQLConnnection pointing at database with table TestParm
TDatasetProvider with property Dataset pointing at TSQLStoredProc
TSQLStoredProc with StoredProcName pointing at TestSP (see above)
Should my TestInput input parameter be filled in at Params?

3. On the Client side:
TSQLConnection with driver Datasnap
TSQLQuery with SQL string: 
select * from testsp  where TESTINPUT = :TESTINPUT;

Should any parameters be set in the Params property?

I tried all kinds of combinations, but get error messages all the time. I.e. 
dbx.sql is an unrecognized command type, invalid ordinal 0, parameter mismatch 
for procedure TestSP.

What should be the correct combination of components, parameters for this?

Please help!

Regards,

Franz