Need to get view source into a clob column
766869Aug 2 2011 — edited Aug 2 2011Hi ,
I am trying to get the data by this following query and trying to insert into a table.
SELECT text FROM ALL_VIEWS WHERE TEXT_LENGTH = 43798;
I am trying to get it by this script , but the whole view source is not coming.
---------------------------------------------
DECLARE
C1 CLOB;
BEGIN
C1 := DBMS_XMLGEN.GETXMLTYPE('SELECT text FROM ALL_VIEWS WHERE TEXT_LENGTH = 43798').EXTRACT('//text()').GETCLOBVAL();
--TRUNCATE TABLE XXMNP.Temp;
INSERT INTO XXMNP.Temp values(C1);COMMIT;
END;
Please suggest.