CREATE PROCEDURE prcDoSomething
 @MyString NVARCHAR(max)
AS
...

var ids = "very long string...";
const string sql = @"EXEC prcDoSomething :MyString";
var query = NHibernateSession.CreateSQLQuery( sql );
query.SetString( "MyString", ids );
query.ExecuteUpdate();