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
Messages: 1
Registered: December 2006
Junior Member

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.

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
Messages: 619
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: Thu Jul 27 00:14:08 CDT 2017

Total time taken to generate the page: 0.16679 seconds