cursor problem

  • hi members,

    I need help to make a cursor in a stored procedure to make it skip to the next id if that particular row has an error. and also I want to display the error number,error message and also for which record that error came in the database and record this error number,error message and also the record details into some table.

    I wanted only through cursor as I know the below scenario can be done through set based sql and also through Common table expressions. But I want through cursor and also

    My cursor want to increase sal by 100 to each empno.

    Eg: empno ename sal

    10 xxx 1000

    20 yyy 2000

    30 zzz 3000

    errortable

    errorno errormessage empno ename sal

    20 some error 20 yyy 2000

    If anyone can give with example it would be great.

    Thanks

    sai

  • You could try using "try...catch..."

    BEGIN TRY

    { sql_statement | statement_block }

    END TRY

    BEGIN CATCH

    [ { sql_statement | statement_block } ]

    END CATCH

    [ ; ]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply