OraFAQ Forum: Forms » How can save record into hr

Home » Developer & Programmer » Forms » How can save record into hr_employee table

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

How can save record into hr_employee table [message #231285]

Mon, 16 April 2007 04:43

habib.khan
Messages: 20
Registered: March 2007
Location: Islamabad

Junior Member

hello,
i am using oracle 10g.i am facing a problem "FRM-40508 : ORACLE ERROR :UNABLE TO INSERT THE RECORD",WHEN I SAVE THE RECORD.any one can help me.Please tell me how can solve this problem.
Thanks in advance.
habib

Report message to a moderator

Re: How can save record into hr_employee table [message #231305 is a reply to message #231285]

Mon, 16 April 2007 06:25

shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai

Senior Member

hi,

does this 2 links provides any help to you?

link1

link2

regards,
shanth.

Report message to a moderator

Re: How can save record into hr_employee table [message #231932 is a reply to message #231285]

Wed, 18 April 2007 20:59

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

Senior Member
Account Moderator

Does your form use default database handling or do you have your own 'key-commit', 'on-', 'pre-', or 'post-' 'insert' or 'update' triggers? Please post your code.

David

Report message to a moderator

Re: How can save record into hr_employee table [message #232065 is a reply to message #231932]

Thu, 19 April 2007 04:36

habib.khan
Messages: 20
Registered: March 2007
Location: Islamabad

Junior Member

hi David,
Thank you for your reply.I have no my own triger.i just use data block and try to save the record but record not save.An error occur "Unable to save the reocrd".I think a database triger is used because this database is designed by my "Sir" and he is not here now.
Thanks again.
habib khan.

[Updated on: Thu, 19 April 2007 04:43]

Report message to a moderator

Re: How can save record into hr_employee table [message #232070 is a reply to message #232065]

Thu, 19 April 2007 04:44

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

Please check may be your block has some item which are non database and you set them DATABASE ITEM = YES

or if you have made any change in database then refresh the database from objective navigator.

[Updated on: Thu, 19 April 2007 04:45]

Report message to a moderator

Re: How can save record into hr_employee table [message #232266 is a reply to message #232070]

Thu, 19 April 2007 23:48

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

Senior Member
Account Moderator

Did this Form display this error before your "Sir" went away or have you modified the form? If the latter, have a good hard look at the changes that you have made and check for the issue detailed by 'kamran.it'.

David

Report message to a moderator

Previous Topic:	Sending Fax using Oracle Forms 6i
Next Topic:	ANIMATED GIF SUPPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 06:04:37 CDT 2025