upravljenje greskama u storage procedurama
Imama sledecu storage proceduru
ALTER PROCEDURE [dbo].[PreuzmiRadniNalog]
-- Add the parameters for the stored procedure here
@rNalId varchar(20)
AS
BEGIN
DECLARE @ErrNo as int,
@ErrMsg as VarChar(255)
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
-- SET NOCOUNT ON;
-- Insert statements for procedure here
If (SELECT DatumZav FROM RadniNalozi
WHERE rNalId = @rNalId) = null
BEGIN
SET @ErrNo = 50001
SET @ErrMsg = 'Neispravni podaci iz navedenog Radnog Naloga'
GOTO Rais_Error
END
Rais_error:
RAISERROR @errno @errmsg
--ROLLBACK TRANSACTION
END
kada probam da je izvrsim gde je uslov = true javlja mi sledecu gresku,
da li zna neko kako upravljati porukama kroz stored proceduru
Msg 2732, Level 16, State 1, Procedure PreuzmiRadniNalog, Line 29
Error number 0 is invalid. The number must be from 13000 through 2147483647 and it cannot be 50000.
 |  |
 |
