We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL-Server Stored Procedure

ASchindler
ASchindler asked
on
Medium Priority
213 Views
Last Modified: 2011-08-18
I call a stored procedure in MS SQL-SERVER.
Everything worked fine. I Installed SQL-Server Service Pack last week. Now the SP works fine from ISQL and aborts when it is called from Delphi. I get no error in Delphi.
What can I do to ensure proper execution of the SP?
Comment
Watch Question

Commented:
Do you use the TStoredProc component?
Are there any parameters of the stored proc necessary?
Do you fill the parameters correctly?
Are the types of the parameters specified correctly in the component?
With the correct type?
Try renewing the TStoredProc component.
Do you use the same parameters from ISQL and Delphi. Maybe your storedproc generates a server exception with the parameters from Delphi.

More info is needed to give an answer to your question.

Regards
Jacco

Author

Commented:
I use a TQuery
There is one Parameter (INteger)
I assign the SQL Statment in Delphi
"EXPORT_ZNS_NENNUNGEN 97177"
I tried TStoredProc, TQuery, ODBCExpress Thstmt, Odbcexpress Query,... . I made a new Form in Delphi -
The Result was the same.
The Procedure Call is transfered to the SQL-Server (ich checked it by SQL Trace) but the Server canceles the Procedure without any Error Message.
I Evaluated the SQL Message (SQL_SUCCESS_WITH_INFO) but there was no hint why the procedure was aborted.
A week ago the Code works fine.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.