Non-default SQLFORMAT + cursor column

Alexander Chudesnov

Hello, here's the problem I've encountered with the SQLFORMAT feature using SQLcl with Oracle 11g, I thought maybe you could shed light on its source, and maybe suggest a solution.

SQLcl 4.2.0.16.112.0616 RC fails to execute a SQL statement with CURSOR columns on an 11.2.0.1.0 database with any non-default SQLFORMAT. The corresponding column's type in the output is "NUMBER", no data is returned for this column, and an error message "getOracleObject not implemented for class oracle.jdbc.driver.T4CResultSetAccessor" is displayed (No version of JDBC I've tried so far implements this method).

When I 'set SQLFORMAT default', this statement is executed without error messages and data is fetched and displayed, but the output layout is broken.

Here is an example gist where I execute the same query in SQLPlus, SQLcl with default format and SQLcl with JSON format: https://gist.github.com/Chudesnov/06324d480290a7a916aaec6ef9173083

thatJeffSmith-Oracle

Simply put, it's a bug.

Alexander Chudesnov

Well, at least now I'm sure that you know about it.