ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL

[GoogleCodeExporter]

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!

Original issue reported on code.google.com by resh...@gmail.com on 16 Apr 2013 at 2:59

[GoogleCodeExporter]

Based on comment #8 on issue 40 by iulian.ghinea: 

Original comment by resh...@gmail.com on 16 Apr 2013 at 5:55

[GoogleCodeExporter]

fixed in release 2.1

Original comment by resh...@gmail.com on 30 Apr 2013 at 10:04

• Changed state: Fixed