Oracle Forms Error 41003
function cannot be performed here" [message #607130] Mon, 03 February 2014 02:49 mist598 Messages: 1157Registered: February 2013 Location: Hyderabad Senior Member Hi, The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger. DO_KEY('execute_query); A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here". What can i do to fix this error? Thank You Report message to a moderator Re: FRM-41003: "This function cannot be performed here" [message #607131 is a reply to message #607130] Mon, 03 February 2014 02:51 cookiemonster Messages: 12341Registered: September 2008 Location: Rainy Manchester Senior Member execute_query (and enter_query) only works in database blocks, not control blocks. So you would first have to navigate to a database block. Report message to a moderator Re: FRM-41003: "This function cannot be performed here" [message #607132 is a reply to message #607131] Mon, 03 February 2014 02:54 mist598 Messages: 1157Registered: February 2013 Location: Hyderabad Senior Member Thank You for early reply cookiemonster.. , Can you please eloborate me Report message to a moderator Re: FRM-41003: "This function cannot be performed here" [message #607133 is a reply to message #607130] Mon, 03 February 2014 03:07 mist598 Messages: 1157Registered: February 2013 Location: Hyderabad Senior Member I Set the Mouse Navigate property to No for the Execute Query button. Now it worked fine.. Report message to a moderator Re: FRM-41003: "This function cannot be performed here" [message #607135 is a reply to message #607133] Mon, 03 February 2014
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank http://www.orafaq.com/forum/t/191386/ message. Please type your message and try again. More discussions in Technical Questions All PlacesOracle ApplicationsEndeca Experience ManagementTechnical Questions This discussion is archived 0 Replies Latest reply on Feb 12, 2015 9:33 AM by https://community.oracle.com/thread/3673537 2814931 FRM-41003-This function cannot be performed here 2814931 Feb 12, 2015 9:33 AM Hi all i am getting FRM-41003-This function cannot be performed here error while retreiving the data in forms...please help... I have the same question Show 0 Likes(0) 758Views Tags: none (add) This content has been marked as final. Show 0 replies Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
You are here: Home > Oracle Questions & Answers > 1Z0-141 > http://www.aiotestking.com/oracle/what-can-you-do-to-fix-this-error/ What can you do to fix this error? What https://www.experts-exchange.com/questions/20613236/Create-an-Oracle-Forms-data-block-using-a-stored-procedure.html can you do to fix this error? Posted by seenagape on January 23, 2012 Leave a comment (0) Go to comments The Orders form has two base table blocks and a control block. There is an Execute Query oracle forms button in the control block with the following When-Button-Pressed trigger:DO_KEY(‘execute_query);A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here".What can you do to fix this error? A.Define a Key-Exeqry trigger oracle forms error at the form level. B.Set the Mouse Navigate property to No for the Execute Query button. C.Set the Query All Records property to Yes for the Order Items block. D.Set the Query Allowed property to Yes for at least one item in the Order Items block. Show Answer 1Z0-1411Z0-141 Discussion No comments yet. Leave a Reply Cancel reply Comment Name * Email * Recent commentsPavel wrote I agree for D (2 1) Improved code for testing below: public class SortAndSearch2 { ...Pavel wrote C - variable name is the same but cannot be. Name was declare in Pupil.fghfgh wrote errorRoscoe wrote The answers are B and D. E is incorrect, user's default tablespace is not the same as temp ...Football Club wrote Informative and precise Its hard to find informative and precise info but here I found Questions & Answer collection
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Create an Oracle Forms data block using a stored procedure Want to Advertise Here? Solved Create an Oracle Forms data block using a stored procedure Posted on 2003-05-12 Oracle Database 1 Verified Solution 3 Comments 16,104 Views Last Modified: 2009-09-11 Does anybody know where I could find some detailed documentation about creating Oracle Forms data blocks using stored procedures? 0 Question by:broker007 Facebook Twitter LinkedIn Google LVL 47 Active 1 day ago Best Solution byschwertner Why base a block on a stored procedure? --------------------------------------- Basing a block on a stored procedure is an advanced operation to do the following: 1. Reduce network traffic Go to Solution 1 Comment LVL 47 Overall: Level 47 Oracle Database 47 Message Active 1 day ago Accepted Solution by:schwertner2003-05-12 Why base a block on a stored procedure? --------------------------------------- Basing a block on a stored procedure is an advanced operation to do the following: 1. Reduce network traffic through array processing as the sql statements are processed by the pl/sql engine on the server side. 2. Perform complex computations 3. Update and query multiple tables 4. Perform validation and DML on server-side. What is a REF Cursor? -------------------- REF cursors hold cursors in the same way that VARCHAR2 variables hold strings. This is an added feature that comes with PL/SQL v2.2. A REF cursor allows a cursor to be opened on the server and passed to the client as a unit rather than one row at a time. One can use a Ref cursor as a target of assignments and can be passed as parameters to the Program Units. Ref cursors are opened with an OPEN FOR statement and in all other ways, they are the same as regular cursors. What is a table of records? -------------------------- A ta