ODBC Stage - Error Codes

[wong_ricky]

On the ODBC stage, I called a stored procedure written in SQL Server 2005. The stored procedure includes error handling. When the error occurs in the stored procedure, it supposed to fail the ODBC stage but it doesn't. I appreciate very much for anyone could help me. Also, how does the error codes works in the ODBC stage?

Thank you.

[sachin1]

i am curious about your stored procedure template, can just post your stored procedure template like below

procedure_1(num1 in,num2 out )...........