This content has been marked as final. Show 8 replies
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
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