Home » SQL & PL/SQL » SQL & PL/SQL » Convert TABLE type object into CLOB
Convert TABLE type object into CLOB [message #207512] Tue, 05 December 2006 20:44 Go to next message
anand_anan2k
Messages: 1
Registered: December 2006
Junior Member
Hi,

I have an existing procedure which gives me XML o/p in the TABLE type objects (TYPE XMLBUFFER_TABLE IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;)

I want to convert that table object into CLOB variable.

Is there any direct OR indirect way of conversion possible for this.

Any help on this will be appreciated greatly.

Thanks,
Elangovan.
Re: Convert TABLE type object into CLOB [message #207582 is a reply to message #207512] Wed, 06 December 2006 02:29 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Why don't you create a wrapper for you procedure and concatenate all lines of PLSQL table into a single CLOB?
Previous Topic: max no. of columns
Next Topic: SQL Server to Oracle
Goto Forum:
  


Current Time: Sat Dec 03 12:25:37 CST 2016

Total time taken to generate the page: 0.11155 seconds