OraFAQ Forum: Forms » ORA-00001

Home » Developer & Programmer » Forms » ORA-00001

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00001 [message #133852]

Mon, 22 August 2005 07:23

VSPB
Messages: 27
Registered: August 2005

Junior Member

How do i show this is error message ORA-00001 at forms runtime... i want to show message, which particular unique key is being violated... right now it is just showing forms error message FRM-40508 for duplicate entry...

Report message to a moderator

Re: ORA-00001 [message #133939 is a reply to message #133852]

Mon, 22 August 2005 18:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/m/120173/67467/?srch=message#msg_120173.

David

Report message to a moderator

Re: ORA-00001 [message #133987 is a reply to message #133939]

Tue, 23 August 2005 01:33

VSPB
Messages: 27
Registered: August 2005

Junior Member

i went to the link sent by you. but didnt find what i wanted. i juz wanted to know that when u try to insert duplicate value using insert into statement in the SQL+ it gives error message:-

ORA-00001: unique constraint (SAILMMD.UQ_SUPPLIER_NAME) violated

but this is not a forms error. and forms error for duplicate entry FRM-40508 can be shown in ON-ERROR TRIGGER using error_code and error_text. but how can i show a non-forms error message if a duplicate entry is done.

Please help...

Report message to a moderator

Re: ORA-00001 [message #133988 is a reply to message #133987]

Tue, 23 August 2005 01:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Use code like the code in the link and a message statement to show whatever text you wish to display.

David

Report message to a moderator

Previous Topic:	One question
Next Topic:	D2K(Clear Block)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:22:58 CDT 2024