sybase procedure error handling

[Guest_imported]

Hi.

In a stored procedure, if an error occured, how to handle this error and continue the process? Something as on error do something.

 

[somnath74]

You can check for @@error just after the sql execution.This @@error is a system level variable .
If @@error <> 0
there is an error do something ,
else
proceed