cursor problem

• blnbmv

  SSC Eights!

  Points: 900

  More actions

  August 21, 2008 at 12:37 pm

  #191461

  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

• gemspring2004

  Grasshopper

  Points: 15

  More actions

  April 15, 2016 at 3:30 am

  #1872255

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

  BEGIN TRY

  { sql_statement | statement_block }

  END TRY

  BEGIN CATCH

  [ { sql_statement | statement_block } ]

  END CATCH

  [ ; ]