Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

raise_application_error not showing error message

863006Jun 23 2012 — edited Jun 24 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2012
Added on Jun 23 2012
11 comments
1,558 views