topic Re: ORA-06510: PL/SQL: unhandled user-defined exception in Operating System - HP-UX

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

Fall_2 — Fri, 25 Apr 2003 14:47:24 GMT

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

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

Brian Crabtree — Fri, 25 Apr 2003 18:42:41 GMT

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

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

Yogeeraj_1 — Sat, 26 Apr 2003 03:48:03 GMT

hi,

also post the output of:

show parameter utl_file_dir

regards
Yogeeraj

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

Indira Aramandla — Mon, 28 Apr 2003 01:31:10 GMT

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

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

Fall_2 — Mon, 28 Apr 2003 06:20:43 GMT

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

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

Fall_2 — Mon, 28 Apr 2003 06:36:35 GMT

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;

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

Yogeeraj_1 — Mon, 28 Apr 2003 08:56:44 GMT

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

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

Fall_2 — Mon, 28 Apr 2003 09:02:50 GMT

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.