No, stored procedures work both with Remote or Local Sessions, exactly the same way.
The language for writing stored procedures is standard PSM/SQL.
You can find information about it here: https://www.elevatesoft.com/manual?action=contents&id=edb2sql