Set Chained Off

Hello All,

I am facing a problem regarding Set Chained Off, i have
created the webservice and my webservice is calling a stored
procedure sr_m1 which is in UnChained Mode and this sr_m1 is
calling another Stored Procedure inside it(sr_m2). I have
set ?SERVER_INITIATED_TRANSACTIONS=false in my connection
cache but for sr_m1 its not showing any error but for sr_m2
its showing the following error "CORBA Unknown run only in
unchained transaction mode. The'SET CHAINED OFF' command
will cause the current session to use unchained transaction
mode. please help me through this mas iam at critical phase
of my project.

Thanks in advance,
Yaqub.
0
yakubpasha
12/8/2010 7:08:07 AM
sybase.ase.general 8655 articles. 0 followers. Follow

1 Replies
1505 Views

Similar Articles

[PageSpeed] 21
Get it on Google Play
Get it on Apple App Store

Hi

What mode is sr_m2 supposed to run under?

From something liek ISQL when you do:

set chained off

exec sr_m1

What happens?

Thank you,

-Paul

<yakubpasha.md@gmail.com> wrote in message 
news:4cff2ed7.346c.1681692777@sybase.com...
> Hello All,
>
> I am facing a problem regarding Set Chained Off, i have
> created the webservice and my webservice is calling a stored
> procedure sr_m1 which is in UnChained Mode and this sr_m1 is
> calling another Stored Procedure inside it(sr_m2). I have
> set ?SERVER_INITIATED_TRANSACTIONS=false in my connection
> cache but for sr_m1 its not showing any error but for sr_m2
> its showing the following error "CORBA Unknown run only in
> unchained transaction mode. The'SET CHAINED OFF' command
> will cause the current session to use unchained transaction
> mode. please help me through this mas iam at critical phase
> of my project.
>
> Thanks in advance,
> Yaqub. 


0
Paul
12/13/2010 4:17:10 PM
Reply:

Similar Artilces:

SET CHAINED OFF
Hi, I have developed Webservices using Sybase webservice tool kit and my application server is EA Server 5.3, i have a problem while calling a stored procedure using Sybase Webservice, when i invoke the webservice , the service should return the results based on the Stored procedure, but i am getting an error like below "CORBA Unknown run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode" i have mentioned connetion.getAutoCommit(true) in my java code before calling the Stored Pr...

ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...

SET CHAINED OFF
Hi, I have developed Webservices using Sybase webservice tool kit and my application server is EA Server 5.3, i have a problem while calling a stored procedure using Sybase Webservice, when i invoke the webservice , the service should return the results based on the Stored procedure, but i am getting an error like below "CORBA Unknown run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode" i have mentioned connetion.getAutoCommit(true) in my java code before calling the Stored Pr...

ASE settings
Hello there, Although I am a newbie, I am working on a performance study to find the optimal settings of our SQL-server (ASE 11.9.2). Sofar I have made some changes on the following sp_sysmon settings: * number of open objects 500 => 1000 * number of open indices 500 => 1000 * number of open databases 8 => 10 Since the test-setup for measuring performance is quite complex and measuring changes is timeconsuming, I would like to ask there are suggestions for more performance tuning parameters. For completeness, I have added the system config and sp_sysmon log. ===...

ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...

SET CHAINED OFF
Hi, I have developed Webservices using Sybase webservice tool kit and my application server is EA Server 5.3, i have a problem while calling a stored procedure using Sybase Webservice, when i invoke the webservice , the service should return the results based on the Stored procedure, but i am getting an error like below "CORBA Unknown run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode" i have mentioned connetion.getAutoCommit(true) in my java code before calling the Stored Pr...

SET chained off
Hi all I have a problem call SP from Sybase 12 within PB7 The SP contain the Set command 'SET chained off', at the run time PB7 give me this message 'Set Chained Command not allowed within multi-statement transaction' ! Any help Thanks in advance -- ---- KPMG/Barents Group C.O. Manager Waleed Seada Set Autocommit to TRUE... /ck "Waleed Seada" <ws_spartan@hotmail.com> wrote in message news:7WPGICirBHA.206@forums.sybase.com... > Hi all > > I have a problem call SP from Sybase 12 within PB7 > The...

SET chained off
Hi all I have a problem call SP from Sybase 12 within PB7 The SP contain the Set command 'SET chained off', at the run time PB7 give me this message 'Set Chained Command not allowed within multi-statement transaction' ! Any help Thanks in advance -- ---- KPMG/Barents Group C.O. Manager Waleed Seada Please do not crosspost! "Waleed Seada" <ws_spartan@hotmail.com> wrote in message news:Z7dFx8irBHA.204@forums.sybase.com... > Hi all > > I have a problem call SP from Sybase 12 within PB7 > The SP ...

set chained on
If I issue a set chained on in a stored proc which calls another stored proc, is the set chained on going to have any effect in the called stored proc yes, since you've now started a transaction with the 'chained'. all called stored procs will behave as part of that big transaction until you commit the outer-most transaction. > If I issue a set chained on in a stored proc which calls > another stored proc, is the set chained on going to have > any effect in the called stored proc ...

General settings
Name: Abdelmoughite ABDELMOUMEN Email: moughite75atyahoodotfr Product: Gran Paradiso Alpha 1 Summary: General settings Comments: add the possibility to set several tabs as the default home page. when the browser shut off due to a technical problem, load the same tabs that where used when the problem occurred. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061218 Minefield/3.0a1 ...

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...

superreview requested: [Bug 216751] general.config.filename set in user' s prefs.js overrides setting in all.js
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 216751: general.config.filename set in user's prefs.js overrides setting in all.js https://bugzilla.mozilla.org/show_bug.cgi?id=216751 Attachment 253396: fix MCD https://bugzilla.mozilla.org/attachment.cgi?id=253396&action=edit ...

superreview granted: [Bug 216751] general.config.filename set in user' s prefs.js overrides setting in all.js
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 216751: general.config.filename set in user's prefs.js overrides setting in all.js https://bugzilla.mozilla.org/show_bug.cgi?id=216751 Attachment 253396: fix MCD https://bugzilla.mozilla.org/attachment.cgi?id=253396&action=edit ...

Web resources about - Set Chained Off - sybase.ase.general

Prometheus Being Chained by Vulcan - Wikipedia, the free encyclopedia
Prometheus Being Chained by Vulcan is an oil painting of 1623 by Dirck van Baburen of the Utrecht School , and an example of Baroque chiaroscuro ...

Locked & Chained - Flickr - Photo Sharing!
“Smile, it is the key that fits the lock of everybody's heart.”

Senator Merkley Speaks Out Against Social Security Cuts / "Chained CPI" - YouTube
In an interview with Chris Hayes on MSNBC, Oregon's Senator voiced his disagreement with the President's proposal to use a new cost of living ...

I was chained to couch and tortured for debt, Dubai electrician says
Man was chained, beaten and tortured by compatriot to whom he owed a debt.

Lismore protesters to be chained to cement blocks to stop gas drilling
Protesters are preparing to chain themselves to cement blocks in northern NSW on Monday to prevent Metgasco workers from starting exploratory ...

Blacktown boy found chained to bed (00:37)
A 16-year-old boy has been taken to hospital after being found chained to a bed in his family's home.

Woman chained to floor of cell and raped over five days
A former aeronautical engineer who carefully planned the abduction, imprisonment and repeated rape of a woman he chained in a purpose-built soundproof ...

Autistic boy ‘chained up’ in Blacktown home, rushed to Westmead Hospital - The Courier-Mail Search Search ...
POLICE and paramedics rushed an autistic boy to hospital yesterday after he was left chained to a bed in the back room of his family’s Sydney ...

Autistic boy ‘chained up’ in Blacktown home, rushed to Westmead Hospital - DailyTelegraph Search Search ...
POLICE and paramedics rushed an autistic boy to hospital yesterday after he was left chained to a bed in the back room of his family’s Sydney ...

Autistic boy ‘chained up’ in Blacktown home, rushed to Westmead Hospital
A TEENAGE boy with autism has been taken to hospital after being found chained up inside his family home in Western Sydney.

Resources last updated: 1/5/2016 8:36:28 AM