Hi Stefan.
I am struggling with the same issue.
Could you please post your workaround? I am trying to use it but still no
luck.
Cheers
Carlos
On Tuesday, 11 December 2012 09:39:19 UTC, Stefan EHRET wrote:
>
> Hi everyone! I think I'm going crazy on this one : it's a fairly simple
> scenario and should be documented, but... no!
>
> Here is my stored procedure declaration:
>
>
>> CREATE PROCEDURE [dbo].[spImport] ( @xmlDocument AS XML )
>> AS
>> --
>> GO
>>
>
> Here is my mapping:
>
>
>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"assembly="XXX"
>> namespace="XXX.Entities"><sql-query name="spImport">
>>
> <![CDATA[EXEC [dbo].[spImport] @xmlDocument = :xmlDocument]]>
>> </sql-query>
>>
> </hibernate-mapping>
>
>
>
> And Here is the calling method:
>
>> session.GetNamedQuery("spImport").SetParameter("xmlDocument", document,
>> NHibernateUtil.XmlDoc).ExecuteUpdate();
>
> Now, I'm getting the follinging error:
>
>> While preparing EXEC [dbo].[spImport] @xmlDocument = @p0 an error
>> occurred InnerException: SqlCommand.Prepare method requires all variable
>> length parameters to have an explicitly set non-zero Size.
>
> Thanks for your help, Stefan
>
> PS: I DO have a workaround! I'm looking for a clean solution
>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
