In the SOA 11g, I just created a fresh new project and configured a database adapter to call a stored procedure written inside a package.
The procedure has the in and out parameters. The out parameters are of Oracle table structure types. So the Adapter created the wrapper packages and the .sql and _drop.sql files are generated.
Now I compiled the prject then I see two errors of same type for both the .sql and _drop.sql file.
The error is " Error(1,1): <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected. for .sql and _drop.sql files ".
Similar issue seems with other WSDL or XML files, but I hope the SOA suite support to ignore thise files during compilation and should not give any error,
Any help why this is giving this error.
I removed these two files manually and compiled the project successfully and deployed. When I tried to invoke the BPEL process the procedure throws the
Any help is appreciated.
I've been using SOA Suite for a few years now (10g). Moved to 11g about a year ago and have never had the above problem - until now!
To resolve it I moved the .sql files into the /deploy folder and it compiled OK.
Great - but how come I've never had to do this before? Maybe because all my other 11g projects were migrated from 10g? as in the above problem description, this was a newly created project in 11g.
Edited by: user3048862 on 26-Sep-2012 18:19
Edited by: user3048862 on 26-Sep-2012 18:21