Hi all,
I have some problem at hand while using "Sybase Procedure".
I am suppose to do something like this:
1) Start a transaction from
java code (by means of con.setAutocommit(false))
2) Call X Procedure
3) Call Y Procedure
4) Commit/Rollback Transaction.
Now problem is that Procedure Y was ever been developed, and it is "creating temp. table".
because of which i am getting exception that "Create Table is not allowed inside transaction".
Is anyone came across this problem, and is anyone aware of the solution for this problem.
Note: 1) Using "ddl in tran" to true is not an option for me
2) Above sequence of statement is important.
Your help is greatly appreciated.
, If you need more info. i will let you know.