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.

Report message to a moderator

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: 621
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?

Report message to a moderator

Previous Topic: max no. of columns
Next Topic: SQL Server to Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 13 06:45:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.