Skip to Main Content

Oracle Forms

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!

When-New-Item-instance

Gus9228Feb 24 2017 — edited Mar 3 2017

Good Morning,

I'm new to oracle forms and have a question.  I have a form that has a block and some items in it.  I created a trigger on one of the items to populate a table form a group of texts boxes.  Seems like it should be fairly simple, here is the code I have.  When I start debugging it it runs through it without errors but does not update the database.  Does anyone have any idea what I'm doing wrong.

Thanks,

Gus

Begin

 

INSERT INTO RRS.RRS_FACILITIES  (RRF_FACILITY_ID, RRF_FACILITY_TYPE, RRF_CORRIDOR, RRF_CORRIDOR_MP_OFFSET, RRF_ROADBED, RRF_CREW)

VALUES

(:FACILITY_BLK.RRF_FACILITY_ID,:FACILITY_BLK.RRF_FACILITY_TYPE,:FACILITY_BLK.RRF_CORRIDOR,:FACILITY_BLK.RRF_CORRIDOR_MP_OFFSET,

:FACILITY_BLK.RRF_ROADBED,:FACILITY_BLK.RRF_CREW);

End;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2017
Added on Feb 24 2017
10 comments
8,340 views