OraFAQ Forum: Forms » Unable To Insert Record

Home » Developer & Programmer » Forms » Unable To Insert Record

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

Unable To Insert Record [message #78453]

Mon, 25 February 2002 08:06

Tyler
Messages: 123
Registered: January 2002

Senior Member

I am receiving this error, unable to insert record
FRM-40508, on commit. I thought that it had something to do with the PK and the sequence. so I wrote this in the save button to get a sequence PK into the column...

DECLARE
V_CODE CLASS.CLAS_CODE%TYPE;
BEGIN
SELECT CLAS_CODE_SEQ.NEXTVAL INTO V_CODE FROM DUAL where rownum = 1;
MESSAGE('The PK is'||' '||V_CODE);
:CLAS_CODE := V_CODE;
END;

But I'm still getting the error...ANY SUGGESTIONS??? PLEASE

Tyler

Report message to a moderator

Re: Unable To Insert Record [message #78469 is a reply to message #78453]

Tue, 26 February 2002 00:48

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

u should write the code in pre-insert trigger of the
database block

BEGIN
SELECT CLAS_CODE_SEQ.NEXTVAL INTO :block_name.pk_field_name FROM DUAL
END;

Report message to a moderator

Re: Unable To Insert Record [message #78506 is a reply to message #78453]

Wed, 27 February 2002 01:21

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi,

it is very difficult to say what is going wrong, with the error message u have provided.

when u r running the form and u r getting the error, at that time go to menu and click display error and find out what exactly the error is .

other wise, in pre-insert try to find out what the fileds values are. and also see what are the not null field in the table.

if u still have problem then send me a test case, with table structure and forms

cheers
pratap

Report message to a moderator

Previous Topic:	Re: inserting data in tabular form
Next Topic:	Dynamic Table name problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 14:01:30 CST 2025