Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: Exception handling

    In PL/SQL when you raise an exception, how can you get the calling routine to propagate the error upwards?

    I have a korn shell script which is calling a SQL*plus procedure, and I want to stop processing when an exception is raised.

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    If you use no EXCEPTION HANDLER, then the error will propogate to the calling routine, same as if you include an ERROR HANDLER with WHEN OTHERS. If you're trying to get the Korn shell program to fail also, look into WHENEVER SQLERROR.

    -cf

Posting Permissions

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