ORA-06510: PL/SQL: unhandled user-defined exception

[Fall_2]

Hi,
I have a prog that import csv file into table. When I executed I'm getting an error that I'm not able to figure out, maybe someone will be able to tell me what I doing wrong.
Thanks,
Ibra


SQL> SET SERVEROUTPUT ON
SQL> execute tst_ibra_006.ImpAnyTable( 'd:\Webgate_Ora', 'EP_sys_libibra.exp', '~');
Importing table from file : EP_sys_libibra.exp
EP_sys_libibra
0
BEGIN tst_ibra_006.ImpAnyTable( 'd:\Webgate_Ora', 'EP_sys_libibra.exp', '~'); END;

*
ERREUR ?? la ligne 1 :
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "INTRA.TST_IBRA_006", line 415
ORA-06512: at "INTRA.TST_IBRA_006", line 158
ORA-06512: at line 1

[Brian Crabtree]

Unfortunantly, you only posted a striped down version of the package. Can you run the following and post the result to see where the actual error is occuring.

select * line,text from dba_source where line in ('415','158') and name = 'TST_IBRA_006';

Thanks,

Brian

[Yogeeraj_1]

hi,

also post the output of:

show parameter utl_file_dir

regards
Yogeeraj

[Indira Aramandla]

Hi,

Normally the above errors are caused by the settings of the package ???INTRA.TST_IBRA??? environment variable not matching the 'utl_file_dir' in the init.ora.

Please verify the utl_file_dir parameter. This parameter in the nit.ora must include a directory which is writable by the user.

There can be other causes however. There could be a problem in creating a file in the path you supplied or you are trying to replace existing file, but do not have sufficient permission. Check if you have your path included in the UTL_FILE_DIR parameter in INIT.ORA:

SQL> show parameter utl_file
NAME TYPE VALUE
utl_file_dir string /tmp

Then look for operating system permissions on the directory and file you are trying to create/replace:

Ensure that the user under which the Oracle instance is running has sufficient rights to access this directory. Furthermore, if the file you are trying to create already exists, verify if the owner and file permissions are correct. You need to delete this file or reset file ownership or file permissions. Then you can retry the PL/SQL procedure and the file ownership and permissions:

Hope this helps

[Fall_2]

Hi
Thanks to every body who responded to my message. I just got your response and I will get back with you in asap.
Ibra

[Fall_2]

Brian from your suggestion this is where the error came from:

SQL> SELECT text
2 FROM user_source
3 WHERE name = 'TST_IBRA_006'
4 AND line = any(415,158);

TEXT
--------------------------------------------------------------------------------
iResult := TST_IBRA_006.IMPORTANYTABLE( sUTLDIR, InFile, sDelim );
RAISE ErrINCOMPAT;

[Yogeeraj_1]

hi,

This is definitely related to a User-defined exception. Check your exception handlers in the procedure.

Also, check for possible 'catch -all' WHEN_OTHERS exception handlers. Try to handle any exceptions that could be raised in your code explicitly.

hope this helps!

regards
Yogeeraj

[Fall_2]

you rigth yogeeraj because this is what I'm getting now after some changes in my procedure:


SQL> SET SERVEROUTPUT ON
SQL> execute tst_ibra_006.ImpAnyTable( 'd:\Webgate_Ora', 'EP_sys_libibra.exp', '~');
Importing table from file : EP_sys_libibra.exp
EXCEPTION: 1-User-Defined Exception
Data rolled back
Importing done : 0

Proc??dure PL/SQL termin??e avec succ??s.