Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

checking result of EXECuted statement

Status
Not open for further replies.
varocho

varocho

Programmer
Dec 4, 2000
238
US
I have a stored procedure in which I EXECute some DDL statements (built dynamically). How can I check for an error code and error message? (I'm using version 12.5)
 
Sort by date Sort by votes
Check the value of @@error after each statement?

Greg.
 
Upvote 0 Downvote
Greg, thanks for responding. What kinds of values of @@error signify an error has occurred? A positive number?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

positraction
  • Locked
  • Question
Tracing or Logging of Sybase ASA
Replies
0
Views
110
positraction
positraction
sux2b
  • Locked
  • Question
How to find the version of the database
Replies
1
Views
89
mrdenny
mrdenny
pearlofperls
  • Locked
  • Question
sql query result used in aother query
Replies
1
Views
58
PDreyer
PDreyer
mark1110
  • Locked
  • Question
Help with looping and update statement
Replies
1
Views
108
PDreyer
PDreyer
gchalise
  • Locked
  • Question
BCP of few records from a big table
Replies
1
Views
88
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top