Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: TBD
Affects Version/s: EAP 5.0.0.CR1, EAP 5.0.0.BETA, EAP 5.0.0.CR2, EAP 5.0.0.CR3, EAP 5.0.0.CR4 (FCS and BETA2), EAP 5.0.0.CR5, EAP 5.0.0
Component/s: Documentation
Labels:
None

Affects:

Release Notes
Workaround:

Workaround Exists
Workaround Description:

Hide

A workaround is to add a <database-object> tag containing the command to change the stored procedure to chained mode. This tag needs to follow the tag that defines the new stored procedure.

For example, adding the following after the definition of paramHandling in the mapping for SybaseCustomSQLTest will change the paramHandling stored procedure so that it can be used in a transaction.

<database-object>
<create>
sp_procxmode paramHandling, 'chained'
</create>
<drop/>
</database-object>

Show
A workaround is to add a <database-object> tag containing the command to change the stored procedure to chained mode. This tag needs to follow the tag that defines the new stored procedure. For example, adding the following after the definition of paramHandling in the mapping for SybaseCustomSQLTest will change the paramHandling stored procedure so that it can be used in a transaction. <database-object> <create> sp_procxmode paramHandling, 'chained' </create> <drop/> </database-object>
Release Note Status:
Not Required

is cloned by

JBPAPP-3030 CLONE -HHH-3685 - Sybase - SchemaExport cannot create stored procedures in chained transaction mode