OraFAQ Forum: Forms » Question with Pre-Insert trigger

Home » Developer & Programmer » Forms » Question with Pre-Insert trigger (Forms 11G)

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

Question with Pre-Insert trigger [message #671418]

Wed, 29 August 2018 03:31

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

Hi All,

I have a multi-record DB block. Have written pre-insert trigger which assigns mandatory columns with values. It all works fine when I enter any number of rows and do a commit but throws 'Mandatory column missing error' in this scenario - I add 2 rows -> Delete the 2nd row (DELETE_RECORD) -> Commit.
PRE-INSERT trigger is firing for this particular record but there are NULL values assigned to items which are in PI trigger. Am I missing something?

Thanks,
Rashi

Report message to a moderator

Re: Question with Pre-Insert trigger [message #671454 is a reply to message #671418]

Thu, 30 August 2018 03:11

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'm pretty sure it shouldn't do that.
Try running the form in debug mode to see if any other triggers are firing.

Report message to a moderator

Re: Question with Pre-Insert trigger [message #671461 is a reply to message #671418]

Thu, 30 August 2018 06:30

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

This is what I have in pre-insert trigger. Right after assigning I'm displaying them but they all show NULL. However, values which are entered via screen for this record shows.

SELECT F_SEQ.nextval INTO :block_details.id FROM dual;
:block_details.item1:= :nbt_blk.item1;
:block_details.from_date := TRUNC(SYSDATE);
:block_details.to_date := TRUNC(SYSDATE);

-- Below messages shows NULL for each item
message('ID '||:block_details.id);
message('ITEM 1'||:block_details.item1);
message('EFD '||:block_details.from_date);
message('ETD '||:block_details.to_date);

I'll see if any other trigger causing this.

Thanks You

Report message to a moderator

Re: Question with Pre-Insert trigger [message #671465 is a reply to message #671461]

Thu, 30 August 2018 08:29

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you delete, pre-insert should not fire.
If it's new record then delete should act like clear_record.

Report message to a moderator

Re: Question with Pre-Insert trigger [message #671467 is a reply to message #671465]

Thu, 30 August 2018 09:07

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

Yes, PRE-INSERT is firing on commit (not delete_record). I mentioned delete_record because this error occurs only when I create 2 (or more) rows and delete a row (using delete_record before it is committed/posted) and then click a button which commits.
I got rid of all block level and item level triggers except auto-generated triggers on master-detail block but still the error persist.
What I'm not able to understand is why fields that are assigned value is showing NULL in the same block of code OR why they weren't assigned any values.

Report message to a moderator

Re: Question with Pre-Insert trigger [message #671510 is a reply to message #671467]

Mon, 03 September 2018 07:53

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

My bad...I was setting insert_allowed to FALSE for that block in a procedure that is called from 'Delete' button. This was the reason why I was not able to assign values in pre-insert after 'Delete'.

Thank you

[Updated on: Mon, 03 September 2018 07:53]

Report message to a moderator