Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005
    Posts
    127

    Unanswered: Signal and Resignal

    What is difference between between SIGNAL and RESIGNAL? Both of them seems to have the same type of syntax., kindly help me out to understand things...

    thanks
    Sn

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The difference is this:
    for SIGNAL
    1) the SQLSTATE must be stated unless signalling a named condition
    2) can be placed anywhere
    For RESIGNAL
    1) Must be in condition handler
    2) SQLSTATE is optional, if omitted will use sqlstate that caused condition handler to execute.

    HTH

    Andy

  3. #3
    Join Date
    Apr 2005
    Posts
    127
    Thanks for the info andy.

    regards,
    Sn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •