Question Re: error occured when I select on proxy table from oracle in Technology Q&A

error occured when I select on proxy table from oracle

Former Member — Tue, 22 Oct 2013 00:28:28 GMT

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

Re: error occured when I select on proxy table from oracle

Former Member — Tue, 22 Oct 2013 10:41:26 GMT

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

Re: error occured when I select on proxy table from oracle

Former Member — Wed, 23 Oct 2013 04:59:45 GMT

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 🙂

Re: error occured when I select on proxy table from oracle

Former Member — Wed, 23 Oct 2013 09:10:05 GMT

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.