All the solutions ive found to find your current Creatio version/distribution require you to use a specific MSSQL SQL query that doesnt work with PostgreSQL and doesnt seem to have any easy syntax conversion, does anyone have any ideas?

Hi,

I'm trying to run from a script task a postgres stored procedure, but the postgres database return an error "call" is missing,

What Am I doing wrong ?

bool retCode = false;
var userId = Get<Guid>("UtenteId");
var year = Get<int>("Anno");
 
var userConnection = Get<UserConnection>("UserConnection");
StoredProcedure storedProcedure = new StoredProcedure(userConnection, "SifLoadSurvey");
storedProcedure.WithParameter("Year", year);
storedProcedure.WithParameter("UserId", userId);
storedProcedure.InitializeParameters();
storedProcedure.PackageName = userConnection.DBEngine.SystemPackageName;
 
using (var dbExecutor = userConnection.EnsureDBConnection()) {
	try {
        dbExecutor.CommandTimeout = 0;
        dbExecutor.StartTransaction();
        storedProcedure.Execute(dbExecutor);
        dbExecutor.CommitTransaction();
        retCode = true;
    } catch(Exception ex) {
        dbExecutor.RollbackTransaction();
        retCode =  false;
    }
}
return retCode;