qwazer / oracle-ddl2svn

Automatically exported from code.google.com/p/oracle-ddl2svn
16 stars 3 forks source link

11g - ORA-31600: invalid input value string for parameter string in function stri #27

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
1) 
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

java -jar scheme2ddl.jar -url user/user@server -o server

ok

2) 
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

java -jar scheme2ddl.jar -url user/user@server -o server

error
; nested exception is java.sql.SQLException: ORA-31600: 
недопустимое входное значение 0 параметра 
SEGMENT_ATTRIBUTES в функции SET_TRANSFORM_PARAM
ORA-06512: на  "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: на  "SYS.DBMS_METADATA_INT", line 8330
ORA-06512: на  "SYS.DBMS_METADATA_INT", line 9667
ORA-06512: на  "SYS.DBMS_METADATA", line 4865
ORA-06512: на  line 1

Original issue reported on code.google.com by Michai...@gmail.com on 21 Oct 2011 at 6:46

Attachments:

GoogleCodeExporter commented 9 years ago
fix
scheme2ddl.config.xml

    <!-- http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#BGBJBFGE -->
    <util:map id="transformParams_for_dbms_metadata">
 <!--        <entry key="SEGMENT_ATTRIBUTES" value="0"/>
        <entry key="SQLTERMINATOR" value="1"/>
        <entry key="CONSTRAINTS_AS_ALTER" value="1"/> -->
    </util:map>

Original comment by Michai...@gmail.com on 21 Oct 2011 at 7:24

GoogleCodeExporter commented 9 years ago
ок, доберуться руки - поправлю

Original comment by resh...@gmail.com on 24 Oct 2011 at 4:52

GoogleCodeExporter commented 9 years ago
fixed in release 2.0

Original comment by resh...@gmail.com on 14 Nov 2012 at 6:23