XML Services - publish_lob_ref - SQL query string input limitation

Extensibility

Welcome to the Teradata Forums. Read the guidelines on posting. Email notifications and RSS feeds are available, and also a chronological list of all forum activity.

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.

Search form