error occured when I select on proxy table from oracle

[Former Member]

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..

[Former Member]

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

[Former Member]

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 🙂

[Former Member]

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.