TXDataset can execute any SQL statement. The only difference is that a specific component for stored procedures are not provided, so you just need to build the SQL yourself and get the results using FieldByName. It depends on the underlying component you use server-side. For example, if using FireDac, you can execute stored procedures with TFDQuery (and thus with TXDataset):