To call a stored procedure first create a Procedure which is like this:

Create Procedure CallStoredProcedure(parameters)
Language Database
External Name "Your_Stored_Procedure_Name"

Then just call this procedure with the required parameter