I thought, this stored procedure would return the error code correspondin to exception devision by zero. But actually it is throwing exception.
So for which of the errors/exceptions sybase would return error code without throwing exception and for which of the errors/exceptions sybase would throw an exception directly?
Please help me to undestand the behaviour.
If a stored procedure contains only select statements(one / more than one) what is best way to return error codes when some error occurs?