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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Form status changed

835457Mar 8 2011 — edited Mar 11 2011

Hi All,

I'm using forms 6i and I'm facing a problem : when executing a query on a data block the form's status cahnges to "CHANGED", my code as follows :

GO_BLOCK('Update_Procedures');
SET_BLOCK_PROPERTY ( 'Update_Procedures', Default_Where , 'VisID = ' || '''' || :uVisitID || '''' );
EXECUTE_QUERY;

When I comment (--EXECUTE_QUERY;) EXECUTE_QUERY statement then execute triggr, the form's status is "QUERY" . It means that the problem lies in EXECUTE_QUERY statement.

I didn't make changes to that block before executing the query.
I did a lot of similar queries on other data blocks in the same from with no such problem...I tried a lot of tricks but didn't help, so I need your help

Thanks in advance..

Regards,

LoveSoul

This post has been answered by Amatu Allah Neveen Ebrahim on Mar 9 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2011

Added on Mar 8 2011

#forms, #moved-from-devops

15 comments

7,743 views