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

I created proxy table which is from oracle11g on SA12 GA. when I create it, There is no problem to access. But one day after, There is problem to access proxy table like below..

ora-03127 no new operations allowed until the active operation ends

I have restart oracle db. I am not sure what I have to do on proxy table or oracle db

Please, help me out..

asked 22 Oct '13, 00:28

hakwoo's gravatar image

hakwoo
81448
accept rate: 0%


http://sqlanywhere-forum.sap.com/questions/15849/proxy-table

I have been using SQLAnywhere12(3457:downloaded version) so far for 6 month I don't have problem both Oracle 10g, Oracle 11g

I can't apply other EBF for SQLAny12 or SQLAnywhere16

permanent link

answered 22 Oct '13, 10:41

Ukraine's gravatar image

Ukraine
76336
accept rate: 0%

hi, how can you solve the problem on proxy table? I think I can apply upper SA EBF. But I think you mean you don't anything to solve this problem.. is it right?

Thanks for your reply :)

(23 Oct '13, 04:59) hakwoo

Yes, you are right, I had applied EBF and realized that became unstable so that I reinstalled it. Unfortunately our company using Oracle 10g,11g, MS SQLServer2008 & Azure SQLServer I must family with all dialect of which I don't like, so I centerized by SQLAnywhere. Sales/Purchase is in Oracle 11g, Accounting is Azure SQLServer. As you expected I use Stored Procedure to transfer data which refer to Oracle 11g and send it to Azure SQLServer by daily basis. So far no problem except Microsoft Cloud service change IP address, all of sudden I can't connect to Azure SQLServer. Our company don't allow to register by Host name but IP address.

(23 Oct '13, 09:10) Ukraine
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:

×70
×7

question asked: 22 Oct '13, 00:28

question was seen: 2,358 times

last updated: 23 Oct '13, 09:12