Re: SQL Syntax Error

[C R]

My apologies. I had a typo in my original post. I left out "found".

declare exit handler for not found return concat(error(), 'lookup value not found');

Is my issue with the use of the user declared function: error() ? I couldn't seem to find that error was a keyword or anything. I tried throwing single quotes around 'error'() and I also tried putting a space between error ().

Any input is greatly appreciated.