If you are using an OLE DB connection then you need to use write mode in the connection string (see this post for more info http://community.qlik.com/thread/3223). I find it easier to just use an ODBC connection.
Once connected the format is:
Sql Exec StoredProcedureName 'Variable1', 'Variable2'
Hope that helps.