hi every body,

i have a problem with exception handling in sql server 2005   i have written a code like

CREATE Procedure PaginRec

    (
    @PageNum int,
    @NumOfRec int
    )
as
   
         begin try
                  Begin
                      with DIVRES as (
                          select Row_Number() over(order by Responsible desc)
                          as row, Responsible , Division
                          from Bulist)

        select Responsible,Division
        from DIVRES
        where row between
        (@PageNum - 1) * @NumOfRec + 1 and @PageNum*@NumOfRec
       
                end
        end try


        begin catch
        select  'Pleas enter the right num of parameters'
        end catch

when i execute this stored procedure like this

PaginRec                         (without passing any parameters) 

it should give error message like 'Please enter the right num of parameters

but it doesnt. plz cud u help me to do it in a proper way. 

how msg shud be dispalyed if  user doesnt pass proper parameters

thanks in adv,

regards

learner 

Hi,

 Try and catch block will work if u are calling proc properly.

If any error comes while executing the procedure then the given error message will come.

Here you are not calling a procedure properly

Thanks & Regards

Brijendra Pandey

 There's probably no SQL Server error which triggers the CATCH block to run.  

Why not just check both  @PageNum  and @NumOfRec for NULLs prior to executing the SQL or set them to default values

if they're passed in as NULL?