qwazer / oracle-ddl2svn Goto Github PK

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

saved NTT_VARCHAR2 to file D:/temp/oracle-ddl2svn/TYPE/NTT_VARCHAR2.sql
.java.io.FileNotFoundException: 
D:\temp\oracle-ddl2svn\TYPE\SYSTPnHq\ti7oMMzgQwoBitAwzA==.sql (Системе 
не удается найти указанный путь)
    at java.io.FileOutputStream.open(Native Method)

rename PUBLIC_DATABASE LINK to PUBLIC DATABASE LINK

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Testing the online patch ability with Google code with suggesting the use of a 
system independent newline capability.

get objects changed last week

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

[java] Encountered an error executing the step
[14:11:00][java] org.springframework.jdbc.BadSqlGrammarException: 
StatementCallback; bad SQL grammar [select t.object_name, t.object_type   from 
user_objects t  where t.generated = 'N'    and not exists (select 1           
from user_nested_tables unt         where t.object_name = unt.table_name) UNION 
ALL  select rname, 'REFRESH GROUP', NULL  from user_refresh a ]; nested 
exception is java.sql.SQLException: ORA-01789: query block has incorrect number 
of result columns
[14:11:00][java]

If processing of taskitem fail, scheme2ddl must provide info about failed 
taskitem ( object type and name)

What steps will reproduce the problem?
1. build from
Revision: 146
Author: wallyatkins
Message:
Updated transform params a little. It looks like there should not be an auto 
commit on these calls and Oracle 11g uses TRUE and FALSE instead of 1 and 0.
----
Modified : /trunk/scheme2ddl/src/ru/qwazer/scheme2ddl/Dao.java

2. run againist oracle 10g
3. got error

Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: 
ConnectionCallback; bad SQL grammar []; nested exception is 
java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is not a 
procedure or is undefined

    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)
    at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Dao.java:59)
    at ru.qwazer.scheme2ddl.Dao.fillDDL(Dao.java:46)
    at ru.qwazer.scheme2ddl.Worker.work(Worker.java:39)
    at ru.qwazer.scheme2ddl.Main.main(Main.java:59)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
Caused by: java.sql.SQLException: ORA-06553: PLS-221: 'SESSION_TRANSFORM' is 
not a procedure or is undefined

scheme2ddl.config.xml

add
    <bean id="dao" class="ru.qwazer.scheme2ddl.Dao">
        <property name="map">
            <map>
                <entry key="JAVA_SOURCE">
                    <set>
                        <value>OBJECT_GRANT</value>
                    </set>
                </entry>
                <entry key="DB_LINK">
                    <set>
                        <value>OBJECT_GRANT</value>
                    </set>
                </entry>


and
    <util:set id="types_for_getting_DDL">
        <value>JAVA_SOURCE</value>
        <value>DB_LINK</value>

not export JAVA_SOURCE and DB_LINK
why?

Add support for exporting  job objects craeted with 
SYS.DBMS_SCHEDULER.CREATE_JOB 


see example 
http://stackoverflow.com/questions/3235300/oracles-dbms-metadata-get-ddl-for-obj
ect-type-job

Participationed table support missing?

What do you see instead?

Encountered an error executing the step
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state [99999]; error code [31600]; 
ORA-31600: invalid input value TABLE_PARTITION for parameter OBJECT_TYPE in 
function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31600: invalid input value 
TABLE_PARTITION for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3025
ORA-06512: at "SYS.DBMS_METADATA", line 3076
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1


What version of the product are you using? On what operating system?

$ java -jar scheme2ddl.jar -version
scheme2ddl version 2.0.1
$ java -version
java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) 64-Bit Server VM (build 23.5-b02, mixed mode)

INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31600]; ORA-31600: invalid input value PACKAGE BODY for parameter 
OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2682
ORA-06512: at "SYS.DBMS_METADATA", line 2733
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

[deleted issue]

INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31600]; ORA-31600: invalid input value PACKAGE BODY for parameter 
OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2682
ORA-06512: at "SYS.DBMS_METADATA", line 2733
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

Add support for exporting  dbms_job created with sys.dbms_job.submit

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

add verbose option

oracle-ddl2svn-v1.5.1
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

Export PACKAGE with TYPE 

CREATE OR REPLACE PACKAGE PKG_SPB AS
    TYPE tViewRow   IS RECORD(
                                id NUMBER(38),
                                id_parent NUMBER(38),
                                name VARCHAR2(1024),
                                is_leaf NUMBER(1));
    TYPE tViewTable IS TABLE OF tViewRow;    
END PKG_SPB; 

Exeption 

19.07.2012 19:02:34 
org.springframework.beans.factory.xml.XmlBeanDefinitionReader 
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource 
[org/springframework/jdbc/support/sql-error-codes.xml]
19.07.2012 19:02:34 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
ConnectionCallback; uncategorized SQLException for SQL []; SQL state [99999]; 
error code [31603]; ORA-31603: объект "SYS_PLSQL_77728_DUMMY_1" с 
типом TYPE не найден в схеме "SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1
; nested exception is java.sql.SQLException: ORA-31603: объект 
"SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме 
"SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)
    at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
    at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
    at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
    at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-31603: объект 
"SYS_PLSQL_77728_DUMMY_1" с типом TYPE не найден в схеме 
"SP_MAIN"
ORA-06512: на  "SYS.DBMS_METADATA", line 4018
ORA-06512: на  "SYS.DBMS_METADATA", line 5843
ORA-06512: на  line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1185)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
    at ru.qwazer.scheme2ddl.Dao$1.doInConnection(Unknown Source)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
    ... 4 more

Add --parallel %integer% option 
Default: 1

Specifies the maximum number of threads of active execution operating.
This parameter enables you to make trade-offs between resource consumption and 
elapsed time.

> What steps will reproduce the problem?
  Export schema containing nested table(s).

> What is the expected output? What do you see instead?
  Raised exception: ORA-31603: object "..." of type TABLE not found in schema "..."

> What version of the product are you using? On what operating system?
  1.4, Oracle 10.2.0.3

> Please provide any additional information below.
  "select * from user_objects" return for this object object_type='TABLE', but "dbms_metadata.get_ddl(object_type => 'TABLE', name => '...', schema => '...')" raises exception ORA-31603.

  Master table was exported successfully with resulting script like:
    CREATE TABLE "<schema>"."<master_table>" 
     ("<some_field>" NUMBER NOT NULL ENABLE, 
      ... 
      "<nested_table_field>" "<schema>"."<nested_table_type>" 
     ) 
     NESTED TABLE "<nested_table_field>" STORE AS "<nested_table>";

  Then exp. <nested_table> failed.

is it DBMS_METADATA.SET_TRANSFORM_PARAM
invoking in differnent manner on Oracle 10 and Oracle 11?

when I try run java -jar scheme2ddl -help

I get error 
Exception in thread "main" java.util.zip.ZipException: ═х єфрхЄё  
эрщЄш єърчрээ√
щ Їрщы
        at java.util.zip.ZipFile.open(Native Method)
        at java.util.zip.ZipFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)
        at java.util.jar.JarFile.<init>(Unknown Source)

What do I do wrong?

What steps will reproduce the problem?
1. Run oracle-ddl2svn v1.3 against Oracle 11gR2 instance

What is the expected output? What do you see instead?

Expected to get schema SQL file output but an error occurs after successfully 
connecting to the Oracle instance.

What version of the product are you using? On what operating system?

Using oracle-ddl2svn v1.3 on RHEL5 against an Oracle 11gR2 instance.

Please provide any additional information below.

Here is the error that I receive from executing the JAR:

$ java -jar scheme2ddl.jar -url user/pass@localhost:1521:ORCL -o /tmp/test/

...

ORA-31600: invalid input value 0 for parameter SEGMENT_ATTRIBUTES in function 
SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8330
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9667
ORA-06512: at "SYS.DBMS_METADATA", line 4865
ORA-06512: at line 1

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

Add to gradle.build task with publish release to googlecode.com

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

fill config with predefined objects from oracle site

INFO: Loading XML bean definitions from file 
[/home/pimenov_pa/sql/scheme2ddl.config.xml]
08.11.2012 9:48:53 
org.springframework.beans.factory.support.DefaultListableBeanFactory 
preInstantiateSingletons
INFO: Pre-instantiating singletons in 
org.springframework.beans.factory.support.DefaultListableBeanFactory@4e044e04: 
defining beans [dataSource,dao,ty
pes_for_getting_DDL,exclude_map_prefixes,exclude_map_pattern,fileWorker,transfor
mParams_for_dbms_metadata,ddlFormatter,worker]; root of factory hierar
chy
start getting of user object list for processing
list.size() before filter = 60
get 60 objects
08.11.2012 9:48:54 
org.springframework.beans.factory.xml.XmlBeanDefinitionReader 
loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource 
[org/springframework/jdbc/support/sql-error-codes.xml]
08.11.2012 9:48:54 org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, 
Oracle, PostgreSQL, Sybase]
Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: 
CallableStatementCallback; uncategorized SQLException for SQL [DECLARE
 callstr VARCHAR2(4000);
BEGIN
  dbms_job.user_export(101, callstr);
:done := callstr; END;]; SQL state [99999]; error code [23421]; ORA-23421: 
íîìåð çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4
; nested exception is java.sql.SQLException: ORA-23421: íîìåð 
çàäàíèÿ 101 íå ñîîòâåòñòâóåò çàäàíèþ â 
î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:944)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:956)
        at ru.qwazer.scheme2ddl.Dao.findDbmsJobDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.getPrimaryDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Dao.fillDDL(Unknown Source)
        at ru.qwazer.scheme2ddl.Worker.work(Unknown Source)
        at ru.qwazer.scheme2ddl.Main.main(Unknown Source)
Caused by: java.sql.SQLException: ORA-23421: íîìåð çàäàíèÿ 101 íå 
ñîîòâåòñòâóåò çàäàíèþ â î÷åðåäè çàäàíèé
ORA-06512: íà  "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: íà  "SYS.DBMS_IJOB", line 529
ORA-06512: íà  "SYS.DBMS_JOB", line 284
ORA-06512: íà  line 4

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
        at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4719)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
        at ru.qwazer.scheme2ddl.Dao$CallableStatementCallbackImpl.doInCallableStatement(Unknown Source)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:928)
        ... 6 more

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Add remove slash formatter option

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

What steps will reproduce the problem?
1. Run oracle-ddl2svn against an Oracle instance that has been run through the 
US DoD Security Technical Implementation Guide for Oracle

What is the expected output? What do you see instead?

Instead of connecting to the database to initiate the creation of the DDL for 
the specified schema an ORA-28040 exception is thrown. (No matching 
authentication protocol)

What version of the product are you using? On what operating system?

Using oracle-ddl2svn v1.2 on RHEL 5 and connecting to an Oracle 11gR2 instance.

Please provide any additional information below.

In our environment the Oracle client connecting to the Oracle DB must match the 
version in order to follow the rules of security and information assurance. 
Bundling the Oracle JDBC client JAR might actually be against Oracle's terms of 
use and, in this case, it makes it harder to use your utility. You may want to 
consider allowing the user to specify the path to their local Oracle client 
JAR. 

Hi, 

in the current version of the project it is possible to exclude objects with a 
certain prefix, using the exclude_map_prefixes. Could you also add the option 
to exclude objects with a certain suffix?


thanks for the good work.



regards,
John

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state
 [99999]; error code [31603]; ORA-31603: object "XXXXX" of type DB_LINK not found in schema "PUBLIC"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31603: object "XXXXX" of type 
DB_LINK not found in sche
ma "PUBLIC"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

Not sure, but you probably need to map to "DATABASE LINK" (at least that's how 
it's listed in the _OBJECTS views.

Related, is there a way to exclude database links? As this depends on 
privileges on DBA_DB_LINKS view which the user may not have...

scheme2ddl version 2.0.1

/dev/\views

add test db connection option

[FR] Add option check for modification last n minutes

Hello,
I have a problem with a schema export. I gives me the error:



Encountered an error executing the step
org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; 
uncategorized SQLException for SQL []; SQL state [99999]; error code [31600];
ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 3130
ORA-06512: at "SYS.DBMS_METADATA", line 3185
ORA-06512: at "SYS.DBMS_METADATA", line 4863
ORA-06512: at line 1
; nested exception is java.sql.SQLException: ORA-31600: invalid input value LOB 
for parameter OBJECT_TYPE in function GET_DDL


Version of scheme2ddl is 2.0.2, the same server as before when it was a 
successfull export bot on another schema. I used sys as sysdba for connect and 
a single schema in the schema list.

Previously the message was: Saved [...] ....   (a successfull save). But it 
doesn't say what is the current object that the will get the ddl from, in order 
to see what is the object with the problem when it creashes....

The log should be like:

Saving [...] ....       [done]

and [done] should be added after a sucessful save. In case it crashes, on the 
screen will remain the last object it was working on.

Do you have any ideea from this log what is the problem ?

Best regards!

Add each_statement_on_new_line option

What steps will reproduce the problem?
execute the ddl2svn against an Oracle database that has queues defined

What do you see instead?
I see the that "Queue" is invalid object type for GET_DDL Oracle function.

What version of the product are you using? On what operating system?
Oracle 11.2.0.3.0 - 64 bit, Windows Server 2008 R2 Standard

I got a copy of the ddl2svn code and modified the sql code for handling queue 
objects.