sbcole4
asked on
Deltek Vision API ExecuteStoredProcedure
We have created a stored procedure and it is sitting on the db server. We have tested the server locally and against the server directly using the same data as we are sending in the API and the data loads correctly. When we use the API nothing is being loaded. Our parameter in the SP is a XML parameter. We are not getting any errors returned. We have try and catches, begins and ends in the SP and it's getting to the return without issue. But like I said nothing is being loaded. Are we missing something?
singlerow.txt
singlerow.txt
ASKER
The stored procedure was executed just against the database locally using a normal sql execute SP pointing to the payload in as an xml file.
We tested it originally with the test data in the SP originally.
SP.txt
We tested it originally with the test data in the SP originally.
SP.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
we will make that change but, the data went in without issue when it was executed from SQL.
It's the only clue I have now (regional settings from both machines might be different).
sbcole4, a feedback will be appreciated.
Cheers
Cheers
Recommendation to close this question by accepting the above comment as solution.
How are you calling the SP locally?