The APEX 5.1.4 release notes mention a new parameter added to the command line export -expComments: Export developer comments which is something I suggested several years ago and built a home grown workaround for so I was happy to see it built into the product.
But when I downloaded the APEXExport.class and used it as follows (simply replacing the existing class file from 5.1.3), it errors out
What am I missing?
Thanks
java -Doracle.net.tns_admin=$ORACLE_HOME/network/admin -Djava.security.egd=file:/dev/./urandom -cp .:$ORACLE_HOME/jdbc/lib/ojdbc8.jar oracle.apex.APEXExport -db $APEX_CONNECT_STRING -user $APEX_USER -password $APEX_PWD -expPubReports -expSavedReports -applicationid 225
Exporting application 225
Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-01775: looping chain of synonyms
ORA-06512: at "SYS.DBMS_PICKLER", line 51
ORA-06512: at "SYS.DBMS_PICKLER", line 395
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata12(OracleTypeADT.java:537)
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:477)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:443)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1499)
at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:259)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:124)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:79)
at oracle.jdbc.driver.NamedTypeAccessor.otypeFromName(NamedTypeAccessor.java:83)
at oracle.jdbc.driver.TypeAccessor.initMetadata(TypeAccessor.java:76)
at oracle.jdbc.driver.T4CCallableStatement.allocateAccessor(T4CCallableStatement.java:599)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:201)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:240)
at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1243)
at oracle.apex.APEXExport.get_export_stmt(APEXExport.java:104)
at oracle.apex.APEXExport.ExportFile(APEXExport.java:501)
at oracle.apex.APEXExport.ExportFiles(APEXExport.java:356)
at oracle.apex.APEXExport.main(APEXExport.java:793)
Caused by: Error : 1775, Position : 0, Sql = begin :1 := sys.dbms_pickler.get_type_shape(:2,:3,:4,:5,:6,:7,:8,:9,:10); end;, OriginalSql = begin :1 := sys.dbms_pickler.get_type_shape(:2,:3,:4,:5,:6,:7,:8,:9,:10); end;, Error Msg = ORA-01775: looping chain of synonyms
ORA-06512: at "SYS.DBMS_PICKLER", line 51
ORA-06512: at "SYS.DBMS_PICKLER", line 395
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 31 more