Having probelom in executing Procedures in Database. I am Using MS-SQL Server ,and connecting the Database through JDBC-ODBC Coonection.Following are the short Description of the Probelom that is Encountering.
1.Created Procedure in MS-SQL Server, which intern have 28 Tables Interaction,ie..,Creating Temprory Tables,Selecting Values from Source Table,Pushing the Selected values into Temprory Tables. 2.Execute Above Procedure through Callable Statement. working fine,but it is Working only for Selected tables,ie..,only for first few tables not for 28 tables. 3.While executing the same Procedure in MS-Query Analyser,its working Perfect.
My Suggestions or Questions....
Is there any way to improve the execution of Procedures using Callable Statement?if yes, how can achieve that?
the single procedure has all the tables interaction.if i splitted the same procedures into multiple procedures,then working fine.
i found that some probelom in executing the procedure through Callable statement(While executing same procedure in sql-query analyser its working fine).connected the MS-SQL Server through JDBC-ODBC connection using DSN.whats my question is....
How can i achieve the Execution of multiple trasactions in single procedure using Callable statement?if anyone have idea to improve the above probelom,please provide asap.