Giter VIP home page Giter VIP logo

Comments (6)

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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.

GoogleCodeExporter avatar GoogleCodeExporter commented on May 27, 2024
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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.