Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    5

    Exclamation Unanswered: Exception in Store Procedure or Function

    I've a Problem:

    I can't Intercept any EXCEPTION type in a Store Procere using
    UTL_FILE function.

    FILE_ID := UTL_FILE.FOPEN('D:\ORACLE\CICCIO',COM_NOME_FILE,'A ');

    How can I Intercept these ERRORS???

    EXCEPTION
    WHEN INVALID_PATH THEN RETURN(2);
    WHEN INVALID_MODE THEN RETURN(3);
    WHEN INVALID_MAXLINESIZE THEN RETURN(4);
    .
    .

    It seems that Oracle does not Intercept the key-word INVALID_PATH and INVALID_MODE and INVALID_MAXLINESIZE.....

    thanks, FEDE.

  2. #2
    Join Date
    Jun 2002
    Posts
    2
    By adding the prefix "utl_file" for each exeception:

    exception
    when utl_file.invalid_path then
    ...

Posting Permissions

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