|
Posted by trans53 on 06/17/05 01:37
Hi all and question for you please:
I have very interesting problem:
Our java application(websphere server) calling stored procedure where
we can pass the paramater or not.When we pass the parameter we can see
the result very fast,but when we pass NULL to the stored procedure
nothing returns and we have to kill connection.I noticed in Profiler
that when i kill connection immediatelly after we have RPC:Completed
for the that stored procedure.
The same stored procedure runs with no problem in Query Analizer and
returns data in from 0 to 10 sec even if we pass parameter or not.
what can be the problem in this situation? Thanks
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Discussions-Problem-calling-SP-remotly-ftopict232911.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=807097
Navigation:
[Reply to this message]
|