This content has been marked as final. Show 8 replies
Sounds like a SQL Developer issue. Ask on that forum or ask for help via a SR with support.oracle.com
Ok. I'll write it there.
Just want to add that when doing that with another table which XML column is not registered with any schema, it works great even inside the procedure.
Does it work if you compile the procedure outside SQL Developer, for example using SQL*Plus?
You are right... I translated (and might be incorrect) / assumed that
However, if I execute this query by its own, out of the procedure, it works great.Related to SQL*Plus already...
Yes, I get the same error when I execute the create procedure... statement from SQL*Plus.
What I wanted to say in my first post is that the insert from select query itself, works ok if I execute it outside the procedure: it takes the XML from the remote server and stores it in the local server without problems.
Edited by: user1592798 on 29-ago-2012 5:08
I've been trying different things, but nothing solves the issue. For the moment, the only way to do that is to run the query outside the procedure... any ideas?
Oracle automatically creates some types when registering the schema to which the XML column is linked using the following syntax:
schemaURL => 'http://schemas.conf.com/batch/schemacon',
schemaDoc => '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
[ ... ] '
At [oracle docs|http://docs.oracle.com/cd/B28359_01/appdev.111/b28371/adobjbas.htm#CIHBIBEA] it says you cannot use database links within PL/SQL code to declare a local variable of a remote user-defined type.
With another XML column which is not linked to a XML schema there's no problem. With the schema based XML outside the PL/SQL there's no problem. So, could this schema generated type be the cause of my problem?
Edited by: goyocasero on 06-sep-2012 1:15
Excuse me, I dupplicated my last post.
Edited by: goyocasero on 04-sep-2012 5:19