mORMot Open Source

if you use predefined routes in mormot, it's normal that calling http://localhost:8085/promet/user/1000262/ will return only the data of the table user, you have to write your own code and use PrepareFillMany to retrieve the full data, see https://synopse.info/files/html/Synopse … ml#TITL_49, or better use interface based service

Hi,
   I'm opening this topic, as i'm facing the same problem, passing an array to an oracle stored procedure, i tried bindarray but without success ! i'm getting all the time the error : number or type of argument are invalid ! i tried also with integer array and the same error ! i'm working with oracle 19c but getting the same with 12c

   Here is the code i use :

   - Oracle procedure

TYPE TArrChar IS VARRAY(2) OF VARCHAR2(50);

PROCEDURE TestPLSQLArray(ATable in out TArrChar) IS
BEGIN
    for i in ATable.First .. ATable.Last loop
      ATable(i) := '*' || ATable(i) || '*';
    end loop;
END; 

- Delphi code

var
  Props: TSQLDBOracleConnectionProperties;
  stmt : ISQLDBStatement;
  query : string;
  warrayUtf8 : TRawUTF8DynArray;
begin
  Props := TSQLDBOracleConnectionProperties.Create('localdatabase','','user','pass');
  try
    query :=  'begin Pkg_TFA.TestPLSQLArray(?); end;';
    stmt := Props.NewThreadSafeStatementPrepared(query, false);
    try
      setlength(warrayUtf8,2);
      warrayUtf8[0] := 'toto1';
      warrayUtf8[1] := 'toto2';
      stmt.BindArray(1, warrayUtf8);
      stmt.ExecutePrepared;
    finally
      stmt := nil;
    end;
  finally
    Props.Free;
  end;

Thank you for your help

Thanks for the quick fix, the final solution i implemeted yesteray was exactly what you described, after all it's very easy to check the jwt and authorization in the oneBeforeURI event,

all is working fine now.

There is a way to disable all default method service URI , i mean Root/tablename/ ? i want to use only interface based service, so for now, i used this code in the onBeforeUri event to disable method URI :

  if Ctxt.Command<>execSOAByInterface then
    Ctxt.Error('Method services are not allowed',[403])

Thank you for your quick answer, client will be ajax, so it ll send token in the authorization header, 

I used JWTForUnauthenticatedRequest to validate token, it work fine, but how can I in the server side get the user group from the token, and then call AllowAllByID (in the code of mormot, i saw that the AllowAllByID validate the groupID from the session) !

Thank you for your quick answer ! TDocVariant is a good alternative.

Regards.