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

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

What do you mean ?????

Hi jortiz!

I think you have the same problem:

http://www.dbforums.com/t997729.html

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

Don't worry !

Thanks !

I gotta solve the problem, It was with the UTL file directory !!!

Now It's working correctly !