Java Development Tools

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!

ORA-01867 rised when synonym with DBLink used

YallyJun 11 2009 — edited Feb 6 2012

Hi,

I've created a BC View Object in JDeveloper 10.1.3.4.0 and specified a query for it which is using
synonym with Database link to fetch data from.

When I am trying to test this VO using Application Module test option
I get:

(oracle.jbo.SQLStmtException) JBO-27122: SQL error during statement preparation. Statement: select *
from TEST_S_TABLE

----- LEVEL 1: DETAIL 0 -----
(java.sql.SQLException) ORA-01867: the interval is invalid

I am connecting to database with user who is owner of DBLink and this synonym.
Synonym and DBLink are not Pulblic.

Thanks for any help

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2012

Added on Jun 11 2009

#adf, #application-development-in-java, #jdeveloper, #jdeveloper-and-adf, #oracle

5 comments

1,182 views