Does anyone know the proper syntax for extracting XML data using Impromtu?
I can do the following:
select distinct extract(xml, 'path/text()').getStringVal() from TABLE_NAME
When I add a column of a different type to the same SQL, I receive a -239 error. Example:
select distinct Date...
Hi Windjuly,
Yes, Impromptu 7 supports Oracle CLOB data type. If you want to extract data from the CLOB, you first need to create a table containing an XMLType column. Then you can insert the the data from your table that contains the CLOB.
Step 1:
CREATE TABLE TEST_CLOB
{
ID NUMBER (38)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.