Concat a string with a clob

mlopezal Jul 28, 2012 1:29 PM

In a procedure how can I concat a string with a clob or two clobs?

1. Re: Concat a string with a clob

rareddy Jul 30, 2012 9:42 AM (in response to mlopezal)

I do not believe there is function to concat two clobs. I only see them converting to string and add. However, note that depending upon the size of the clobs this can cause OOM. When you access clos as is they use streaming. Another option is you can write UDF and write that function in the Java to meet your needs.

Ramesh..
Actions
2. Re: Concat a string with a clob

shawkins Jul 30, 2012 11:02 AM (in response to rareddy)

Clob concat is covered by https://issues.jboss.org/browse/TEIID-1248, but has not yet been implemented - which will be done in a memory safe way, just as with SQL/XML functionality. I'll post a workaround to your issue on the original topic.
Actions