Tough day today, I quickly introduced myself to SQL error codes. I have all the code written and theoretically should work. Unfortunately the fetch procedure fails with the following error.
Message ID . . . . . . : SQL0420 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 02/28/12 Time sent . . . . . . : 14:37:30
Message . . . . : Character in CAST argument not valid.
Cause . . . . . : A character in the argument for the CAST function was not
Recovery . . . : Change the result data type to one that recognizes the
characters in the CAST argument, or change the argument to contain a valid
representation of a value for the result data type. Try the request again.
I learned that there is a slew of error codes that can be monitored for. Also received a great link from a previous post. I was aware of the error codes and the need to use them but never had to really figure it out before. Working with debug I was able to monitor SQLSTT variable and found several other issues that were easy to fix. I got a good look at how SQL error codes are generated.
But now I am stuck, I can run the statement in SQL Explorer and interactive SQL green screen and get the desired results. I’ll post the code in the morning, I spent a couple of hours debugging. I am sure it will turn out to be something silly in the morning.
I going to read my Game of Thrones book for a while and get a fresh start in the morning.