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!

update problem in oracle mySQL database link

461913Aug 3 2010 — edited Aug 6 2010

Hi All,
I have a database link created between mySQL (5.1) and Oracle (10.2) and it's working fine when it comes to select statements.
But when I try to run updates I'm getting oracle errors.
Seems something wrong with my sql expression.

UPDATE products@booklink set "is_visible" = 'Yes', "price" = '55', "description" = 'dsds' where "product_id"='456';

Error is
ORA-00904: "description" : invalid identifier

using double quotes for values doesn't sovle the issue and using without any quotes as well.
Any help would be really appreaciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2010

Added on Aug 3 2010

#database, #heterogeneous-connectivity, #link, #mysql, #oracle, #update

21 comments

3,432 views