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!

Oracle Forms - EXECUTE_QUERY - Edited

Arun ThomasJun 11 2016 — edited Jun 13 2016

Hi Friends,

I am trying to create a button which does exactly the same work of 'execute query' button in the smart bar.   

Below are the steps I tried, but isnt working. Please tell me what am I doing wrong.

I am creating a simple form using oracle XE express edition 11g and Oracle forms 10g.

This is a very simple form displays employee details (Form) .

I created a button 'Display' - When Button pressed -> Under PLSQL/Editor  code - >


execute_query;-- this is the only code I typed

When I clicked display button - it gives 'FRM:40202 : Field must be entered.' - E rror .

Additionally the cursor is blinking in the Employee ID field.

Could you please help me how to make it work. BTW the Execute Query button in the Smart Bar works fine.

thanks.. Arun Thomas T

This post has been answered by Manu. on Jun 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2016
Added on Jun 11 2016
13 comments
8,185 views