Hi all,
In the following piece of code:
SELECT count(*)
INTO v_count_name
from fnd_lobs
where file_name = v_file_name
;
IF nvl(v_count_name,0) > 1
THEN
DELETE FROM fnd_lobs WHERE FILE_ID = P_FILE_ID;
COMMIT;
raise_application_error(-20101, 'Duplicate file name!');
RETURN;
end if;
When the error is produced in the application i'm receiving the following:
-20101 : ORA-20101: Message 20101 not found;
product=RDBMS; facility=ORA
ORA-01403: no data found
...instead of my error message specified...
Any ideas?
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
Thanks in advance,
Bahchevanov.