Oracle Database Discussions

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-00920 and ORA-02063.

472903Nov 28 2006 — edited Nov 29 2006

Hi,

I have data in a remote database.
If i do a simple select * on a table in a remote database I can retrieve the data.
But if i have an anonymous block with a cursor and I try to access data from the table in the remote database I get the error saying..
ORA-00920: invalid relational operator
ORA-02063: preceding line from <database name>.

I'm confused as to where the problem might lie.

Please help me solve this problem
M

Message was edited by:
user469900

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2006

Added on Nov 28 2006

#general-database-discussions

4 comments

684 views