Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Question Unanswered: ORA-00000: normal, successful completion

    hello,

    when creating a function, i get this error:
    ORA-00000: normal, successful completion

    how can I prevent it? if it is ok, why giving error?


    CREATE OR REPLACE
    FUNCTION isnumber (p_data VARCHAR2)
    RETURN NUMBER IS v_number NUMBER;
    BEGIN
    BEGIN
    v_number := p_data;
    EXCEPTION WHEN OTHERS THEN RETURN NULL;
    END;
    RETURN v_number;
    END
    isnumber;
    /

    thx

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You are missing an 'END', recode like this:
    Code:
    CREATE OR REPLACE FUNCTION isnumber (p_data VARCHAR2)
        RETURN NUMBER IS v_number NUMBER;
    BEGIN
        v_number := p_data;
        RETURN v_number;
    EXCEPTION WHEN OTHERS THEN RETURN NULL;
    END isnumber;
    /


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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