Comments (6)
Thanks for reporting. I not tested oracle-ddl2svn againist Oracle 11g.
I plan to test it, but i don't know when, becouse I'm busy at work now
But you can configure parameters for dbms_metadata
in scheme2ddl.config.xml
<util:map id="transformParams_for_dbms_metadata">
You can comment line
<entry key="SEGMENT_ATTRIBUTES" value="0"/>
for using default value
Or try to play with value. May be in oracle 11r2 value must be TRUE or FALSE
documetation link http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_metada.htm#i1000135
Please, report about your invetigation if it not dufficult.
Original comment by [email protected]
on 8 Jun 2011 at 4:49
from oracle-ddl2svn.
I am now able to get things to run smoothly after commenting out the three
entries under transformParams_for_dbms_metadata in the scheme2ddl.config.xml
file.
Original comment by wallyatkins
on 8 Jun 2011 at 5:08
from oracle-ddl2svn.
Hi There,
I've found this issue reported on Oracle 11g documentation:
http://docs.oracle.com/cd/B28359_01/java.111/b31224/apxtblsh.htm#i1005380
The only the solution is two wrap the DBMS_METADATA.SET_TRANSFORM_PARAM in a
custom procedure with parameters that are not boolean and call the custom
procedure from jdbc. The custom procedure will then translate to boolean and
call the DBMS_METADATA.SET_TRANSFORM_PARAM proc.
Original comment by [email protected]
on 15 Feb 2012 at 11:12
from oracle-ddl2svn.
Thanks for link to Oracle 11g documentation.
Unfortunally, custom procedure is not applicable for oracle-ddl2svn purpose.
In general case, user of database don't have permission to create custom
procedures
Original comment by [email protected]
on 15 Feb 2012 at 11:46
from oracle-ddl2svn.
You should call DBMS_METADATA.SET_TRANSFORM_PARAM from PL/SQL anonymous block
like this:
sql = "begin DBMS_METADATA.SET_TRANSFORM_PARAM(-1,'" + param + "', " +
transformParams.get(param) + "); end;";
CallableStatement cs = connection.prepareCall(sql);
cs.execute();
This works on Oracle 11gR2.
Original comment by [email protected]
on 7 Mar 2012 at 9:57
from oracle-ddl2svn.
fixed in release 2.0
Original comment by [email protected]
on 14 Nov 2012 at 6:22
- Changed state: Fixed
from oracle-ddl2svn.
Related Issues (20)
- PUBLIC DB_LINKS HOT 1
- Exception in thread "main" java.util.zip.ZipException: ═х єфрхЄё эрщЄш єърчрээ√ щ Їрщы HOT 3
- exclude_map_suffixes HOT 3
- rename PUBLIC_DATABASE LINK to PUBLIC DATABASE LINK in config HOT 1
- ORA-31603: объект "SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме HOT 6
- Add --parallel option HOT 1
- Stop ddl2svn if exception in sheme2ddl HOT 1
- Add support for exporting job objects craeted with SYS.DBMS_SCHEDULER.CREATE_JOB HOT 2
- Add support for exporting dbms_job created with sys.dbms_job.submit HOT 2
- java.sql.SQLException: ORA-23421 dbms_job.user_export(101, callstr) HOT 3
- ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL HOT 6
- ORA-31603: object "XXXXX" of type DB_LINK not found in schema "PUBLIC" HOT 30
- ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL HOT 2
- More verbose error logging HOT 2
- BadSqlGrammarException in REFRESH GROUP HOT 3
- Add to gradle.build task with publish release to googlecode.com HOT 1
- DDL_Get fails on queue object HOT 3
- ORA-31600: invalid input value PACKAGE BODY for parameter OBJECT_TYPE in function GET_DDL
- add support for git
- .svn folder clears with workdir on windows HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from oracle-ddl2svn.