Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

To synchronize a table with a blob column, I created a remote server against a Oracle 11 db and created a proxy table in SA12 against the table in Oracle.

Running sql in SA12, updates and inserts of blob values works from Oracle to Sybase


update table1 set blob_column = (select blob_column from proxy_table1 where id = 1) where id = 1;

However, from Sybase to Oracle I have issues with large blobs

update proxy_table1 set blob_column = (select blob_column from table1 where id = 1) where id = 1;

Do anyone have any experience with passing blob fields between SA12 and Oracle 11 ?

Errormessage: Update operation attempted on non-updatable remote query. alt text

asked 11 Sep '12, 07:42

OBR's gravatar image

accept rate: 0%

edited 11 Sep '12, 08:13

Volker%20Barth's gravatar image

Volker Barth

As you talk about "synchronization" - with SQL Anywhere, that usually means MobiLink (or SQL Remote) technology. But you're "just" refering to remote data access (aka proxy tables), right?

(11 Sep '12, 08:14) Volker Barth

Your assumption is spot on :)

(11 Sep '12, 08:35) OBR

Cf. this FAQ dealing with the same error message and explaining its cause.

If you have to update the remote side (i.e. an insert won't work), then you might try to use a variable to hold the SA blob value and use that variable to update the remote side, such as (untested)

  declare myBlob long varbinary;
  set myBlob = (select blob_column from table1 where id = 1);
  update proxy_table1 set blob_column = myBlob where id = 1;
permanent link

answered 11 Sep '12, 08:13

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

Thank you! Works like a charm!!

(11 Sep '12, 08:20) OBR
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 11 Sep '12, 07:42

question was seen: 2,501 times

last updated: 11 Sep '12, 08:35