Topic
  • No replies
Sree_2012
Sree_2012
18 Posts

Pinned topic sql-execute extension with stored procedures

‏2012-10-05T20:16:03Z |
Hi,

I'm trying to execute a stored procedure sitting on MS SQL Server. Stored procedure is setup to allow a parameter as varchar(max) as input column. When i execute this i keep getting the below error.

<argument type="SQL_LONGVARCHAR" mode="INPUT">
<xsl:value-of select="$information"/>
</argument>

error details:
<sql result="error">
<message>The size (8000) given to the parameter '@P4' exceeds the maximum allowed (4000).</message>
<message>Statement(s) could not be prepared.</message>
</sql>
Any help on this appreciated.
Sree.