When Invoking This Procedure, You Encounter The Error

When Invoking This Procedure, You Encounter The Error


  • 21 Dec, 2011

    When invoking this procedure, you encounter the error:ORA-000: Unique constraint(SCOTT.THEATER_NAME_UK) violated.How should you modify the function to handle this error?1. An user defined exception must be declared and associated with the error code and handled in the EXCEPTION section.2. Handle the error in EXCEPTION section by referencing the error code directly.3. Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.4. Check for success by checking the value of SQL%FOUND immediately after the UPDATE statement.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.