Results 1 to 7 of 7

Thread: Load data

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Unanswered: Load data

    Hello !

    I Got a function that loads a file into a table, but there's a mistake and I don't know why and how to solve it. That's very usefull.

    The file is attached and I used this plsql block to test it :

    DECLARE
    ovaMensajeTecnico VARCHAR2(100);
    lnuResultadoCarga NUMBER;
    BEGIN
    lnuResultadoCarga:=FNC_CARCAR_INFO (
    'x',
    'COL1',
    'C:\',
    'CargaFile.txt',
    ' ',
    ovaMensajeTecnico);
    END;
    /


    ERROR at line 1:
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "SYS.UTL_FILE", line 98
    ORA-06512: at "SYS.UTL_FILE", line 157
    ORA-06512: at "BASE_AVANSOFT.FNC_CARCAR_INFO", line 22
    ORA-06512: at line 5
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    the error is not in the code you provided, but in the function/packaged function called FNC_CARCAR_INFO. The call stack/error message states this.

    Regards
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    What do you mean ?????

  4. #4
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    Hi jortiz!

    I think you have the same problem:

    http://www.dbforums.com/t997729.html
    Last edited by julla27; 05-21-04 at 04:18.
    Regards,
    Julia

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Oops, I have just noticed that you have provided the code in the attachment, my mistake sorry :-)

    I think Julia's advice will serve you well.

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  6. #6
    Join Date
    Jun 2003
    Posts
    294
    Don't worry !

    Thanks !

  7. #7
    Join Date
    Jun 2003
    Posts
    294
    I gotta solve the problem, It was with the UTL file directory !!!

    Now It's working correctly !

Posting Permissions

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