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 view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/BTUStHh7HDYJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
