Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Calling store Procedure.

Author  Topic 

aitor
Starting Member

1 Post

Posted - 2004-04-30 : 03:25:12
Hi,

I Have the next problem:

I have a store procedure in my db which is called from an aplication (developed in Java). That sp contains a cursor which updates regs from a table. After calling from the java application I notice that some regs of the cursor have not entered in it, i mean if the sp executes 200 iterations in the cursor only 150 have worked. But all the iterations enter when i call the sp from the query analyzer!!! and it takes more time too.

Does anybody know something about it?????

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-04-30 : 06:47:41
Can you please post the the sp?

- Sekar
Go to Top of Page
   

- Advertisement -