When trying to run the "sqldump" command in FluidShell, it reports "failed to extract object" for some of the objects. I isolate the problem to the NUMBER Array Types, and the following steps reproduce the problem.
1. Connect to our Oracle 11g database. In schema tree, go to Schema > SYS > Array Types and look at the properties of any of the following array types:
AWRRPT_NUM_ARY
ODCIGRANULELIST
ODCINUMBERLIST
Note that type is NUMBER and length, precision, and scale are not defined.
2. Choose one of these array types. Right click to get the pop-up menu, and choose "Script Object to New Window As" and select "CREATE".
3. NPE error.
NPE occurs at AFTableColumn.getDataTypeDefinitionString(AFTableColumn.java line 1149. The variable "precision" is null. That line of code was introduced in SVN #30158 on 11/14/12.
This code was introduced to fix a customers oracle issue a couple weeks back. I will check code fix for version 13 and 12 as it was back ported.
This code was introduced to fix a customers oracle issue a couple weeks back. I will check code fix for version 13 and 12 as it was back ported.
Issue #7995 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
NPE occurs at AFTableColumn.getDataTypeDefinitionString(AFTableColumn.java line 1149. The variable "precision" is null. That line of code was introduced in SVN #30158 on 11/14/12.