All Forums Extensibility
jcmerceronhome 4 posts Joined 09/10
30 Sep 2010
XML Services - publish_lob_ref - SQL query string input limitation

Hi,

we try to use PUBLISH_LOB_REF Stored procedure with XML Services to publish a document with a SQL Query. But we have to face of the limitation of the SQL query string input (varchar 20000).
our SQL query is about 60000 char.

how can we bypass that limitation ?
any help please?

Regards.

Justin.Li 2 posts Joined 12/09
15 Aug 2011

Is that possible to introduce a view to shrink your query?

You must sign in to leave a comment.