Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

view with dblink on ODI

user11931614Jul 19 2013 — edited Jul 24 2013

hi,

create a view on the target, this view contains a dblink. When I want to see the data in ODI shows me the following error message

anyone can help me

ava.sql.SQLException: ORA-28267: Invalid NameSpace Value

ORA-02063: line precediendo a COM_DMOLPERU

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)

at com.borland.dx.sql.dataset.o.f(Unknown Source)

at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)

at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)

at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)

at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)

at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.initialize(AbstractEditFrameGridBorland.java:628)

at com.sunopsis.graphical.frame.edit.AbstractEditFrameGridBorland.<init>(AbstractEditFrameGridBorland.java:868)

at com.sunopsis.graphical.frame.edit.EditFrameTableData.<init>(EditFrameTableData.java:50)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at oracle.odi.ui.editor.AbstractOdiEditor$1.run(AbstractOdiEditor.java:176)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

at java.lang.Thread.run(Thread.java:662)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2013
Added on Jul 19 2013
13 comments
5,900 views