June 8, 2012 at 3:46 pm
Hello to all!
Here I am again. Seeking the knowledge of the mightiest DBAs. I have a stored procedure that is being called by a method of a web service. This stored procedure returns (amongst several data elements) a column containing an url to a resource (photo). The developer is telling me that when the method is invoked, the url column is blank but when I execute the SP in SSMS, I see that the value is there.
Anyone who can help me school the developer in how to do this correctly? I know I am right, just looking for allies 😉
As always, thanks for all the help and advice.
Regards,
JC
June 8, 2012 at 3:57 pm
Sounds to me like the someone needs to verify that the webservice is actually doing something with the value being returned. Perhaps a little debugging session on the wbservice is in order.
June 8, 2012 at 5:56 pm
Lynn Pettis (6/8/2012)
Sounds to me like the someone needs to verify that the webservice is actually doing something with the value being returned. Perhaps a little debugging session on the wbservice is in order.
Along tyhose same lines - verify that they are actually passing the right value IN. I've had top put up profiler session to capture what they pass in to prove to them they're sending in garbage (and you know the saying - Garbage in... 🙂 )
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 8, 2012 at 6:25 pm
+1 for the suggestions above, in particular the trace, since you can drag said person over to your desk and run exactly what they're sending you and show them the results.
On a side note, what datatype is the url column being provided to them? They may need to doublecheck what the dataset they're using in the webservice is expecting and make sure it's compatible. In particular, if it's something like VARCHAR(MAX) or similar it can behave a little oddly on inbound into the webservices if that's not expected.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply