Skip to Main Content

Oracle Forms

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-02070: database FIREBIRD does not support ROWIDs in this context

SoofiJul 13 2016 — edited Jul 14 2016

Dear All,

     I am using oracle 12c and Oracle forms 11g in windows platform.

I recently made a heterogeneous connection for Firebird database and finally created the database link name @firebird.

I can get the table values from firebird db by using the above dblink. Now I created a view as below,

create view test_vw as

select col1,col2 from tab1@firebird

I build a form by using the above view and now when I execute the form it shows me the error

ORA-02070: database FIREBIRD does not support ROWIDs in this context

Is there any problem in the view I created?

Your valuable suggestions greatly appreciated.

Regards,

Soofi

This post has been answered by Andreas Weiden on Jul 13 2016
Jump to Answer

Comments

Kalpataru

Hi Soofi,

Is your source database and destination database version are same , check the both database version properly ?

Is your view have rowid column ?

If yes then remove the rowid column and try.

You can also check this threads for your reference.

http://www.orafaq.com/forum/t/119514/

ORA-02070: database TO_LINK does not support operator USERENV in this cont

SQL Error: ORA-02070: database does not support in this context

If your issue is not resolved then you can ask it in Oracle Support Forms forum for better help.

Andreas Weiden
Answer

If oyu use a "foreign" database other than Oracle, the concept of ROWID's is unknown.

You can overcome this by changing the Key-Mode of the block to "Non-Updateable" and mark your PK-column-item in the block by Setting the property "Primary Key" to "Yes"

Marked as Answer by Soofi · Sep 27 2020
Soofi

Thanks Andreas Weiden,

It worked for me. But what if my foreign table has no primary key.

Regards,

Soofi

Andreas Weiden

But what if my foreign table has no primary key.

Well, then you are out of luck (and you have a problem with the database-design).

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 11 2016
Added on Jul 13 2016
4 comments
1,726 views