Errors JBO-27122, ORA-22812 During Statement Preparation Using Nested Tables (Doc ID 304973.1)

Last updated on FEBRUARY 02, 2016

Applies to:

Oracle JDeveloper - Version 10.1.2.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Dec-2011***
***Checked for relevance on 30-Sep-2013***


Symptoms

Getting the next stack error when running a UIX page based on any object table like for example OE.categories_tab.

500 Internal Server Error

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement:
SELECT REF(CoursesTab), CoursesTab.SYS_NC_OID$ FROM COURSES_TAB CoursesTab
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:774)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:547)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3422)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:663)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:617)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2593)
at oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1741)
at oracle.jbo.server.ViewRowSetImpl.hasNext(ViewRowSetImpl.java:2648)
at oracle.jbo.server.ViewObjectImpl.hasNext(ViewObjectImpl.java:5446)
at oracle.jbo.jbotester.NavBar.resetButtons(NavBar.java:476)
at oracle.jbo.jbotester.NavBar.setIterator(NavBar.java:153)
at oracle.jbo.jbotester.SimpleForm.setIterator(SimpleForm.java:56)
at oracle.jbo.jbotester.SimpleForm.<init>(SimpleForm.java:50)
at oracle.jbo.jbotester.VOTreeNode.showForm(VOTreeNode.java:112)
at oracle.jbo.jbotester.BaseTree.processTreeMouseClicked(BaseTree.java:387)
at oracle.jbo.jbotester.BaseTree.access$5000171(BaseTree.java:46)
at oracle.jbo.jbotester.BaseTree$TreeMouseListener.mouseClicked(BaseTree.java:494)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5103)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3207)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
## Detail 0 ##
java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:661)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:893)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:693)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:988)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2884)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2925)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:691)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:547)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3422)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:663)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:617)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2593)
at oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1741)
at oracle.jbo.server.ViewRowSetImpl.hasNext(ViewRowSetImpl.java:2648)
at oracle.jbo.server.ViewObjectImpl.hasNext(ViewObjectImpl.java:5446)
at oracle.jbo.jbotester.NavBar.resetButtons(NavBar.java:476)
at oracle.jbo.jbotester.NavBar.setIterator(NavBar.java:153)
at oracle.jbo.jbotester.SimpleForm.setIterator(SimpleForm.java:56)
at oracle.jbo.jbotester.SimpleForm.<init>(SimpleForm.java:50)
at oracle.jbo.jbotester.VOTreeNode.showForm(VOTreeNode.java:112)
at oracle.jbo.jbotester.BaseTree.processTreeMouseClicked(BaseTree.java:387)
at oracle.jbo.jbotester.BaseTree.access$5000171(BaseTree.java:46)
at oracle.jbo.jbotester.BaseTree$TreeMouseListener.mouseClicked(BaseTree.java:494)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5103)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3207)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
----- LEVEL 1: DETAIL 0 -----
java.sql.SQLException: ORA-22812: cannot reference nested table column's storage table
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:661)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:893)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:693)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:988)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2884)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2925)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:691)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:547)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3422)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:663)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:617)
at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2593)
at oracle.jbo.server.ViewRowSetIteratorImpl.hasNext(ViewRowSetIteratorImpl.java:1741)
at oracle.jbo.server.ViewRowSetImpl.hasNext(ViewRowSetImpl.java:2648)
at oracle.jbo.server.ViewObjectImpl.hasNext(ViewObjectImpl.java:5446)
at oracle.jbo.jbotester.NavBar.resetButtons(NavBar.java:476)
at oracle.jbo.jbotester.NavBar.setIterator(NavBar.java:153)
at oracle.jbo.jbotester.SimpleForm.setIterator(SimpleForm.java:56)
at oracle.jbo.jbotester.SimpleForm.<init>(SimpleForm.java:50)
at oracle.jbo.jbotester.VOTreeNode.showForm(VOTreeNode.java:112)
at oracle.jbo.jbotester.BaseTree.processTreeMouseClicked(BaseTree.java:387)
at oracle.jbo.jbotester.BaseTree.access$5000171(BaseTree.java:46)
at oracle.jbo.jbotester.BaseTree$TreeMouseListener.mouseClicked(BaseTree.java:494)
at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:212)
at java.awt.Component.processMouseEvent(Component.java:5103)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3207)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

 

If a query of the table is made on sql plus you get the error as well.

ORA-22812: cannot reference nested table column's storage table

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms