Hi. I posted this thread at XML forum
10546904 and I was told to ask there, at SQL developer forum. This is the question:
I'm using Oracle 11.2.0 and I'm trying to write a procedure which takes some tables stored in one remote server (connected by a database link) and store them in a local server.
I've no problems with usual tables, but I get "ORA-21700: object does not exist" with a table using a registered XMLTYPE.
This is the code in my procedure:
insert into ICF.input_xml n (
ID,
FILENAME,
CREATION_DATE,
XML )
SELECT
o.ID,
o.FILENAME,
o.creationDate,
o.XML
FROM input_xml@remote o;
I get this error in SQL developer when compiling the procedure. However, if I execute this query by its own, out of the procedure, it works great.
Actually, XDB is installed and the same schema is registered with the same name in both servers, so I'm able to make XML operations with these tables in both servers.
When doing that with another table which XML column is not registered with any schema, it works great even inside the procedure.
How could avoid this compiling error (because it actually works)? Or, is there any other way to do that?
Thanks in advance