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

Example:

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

OBR
26691020
accept rate: 0%

edited 11 Sep '12, 08:13

Volker%20Barth's gravatar image

Volker Barth
29.6k294444650

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)

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

answered 11 Sep '12, 08:13

Volker%20Barth's gravatar image

Volker Barth
29.6k294444650
accept rate: 32%

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×62
×37
×27

question asked: 11 Sep '12, 07:42

question was seen: 937 times

last updated: 11 Sep '12, 08:35