Problem with reading XML from url
Hi,
I need help about error when i'm insert xml into xmltype directly from url. This is what i'm doing:
1. create table for url's
CREATE TABLE url_tab
(
URL_NAME VARCHAR2(100),
URL SYS.URIType
);
2. inserting in table for url's
INSERT INTO url_tab VALUES
('Lista na Lekari od site PZZ',
sys.UriFactory.getUri('http://www.fzo.org.mk/XML/LekariLista_SitePzz.xml')
);
3. Creating table for XML
CREATE TABLE xml_lekari_tab ( xml_data xmltype );
4. Inserting directly from url
insert into xml_lekari_tab
select sys.xmltype.createXML(u.url.getClob()) from url_tab u;
But, after insert i got error:
0