Oracle 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 03:12 cookiemonster Messages: 12341Registered: September 2008 Location: Rainy Manchester Senior Member personally I would have added a go_block statement to move the cursor to the block you wanted to execute a query in. Report message to a moderator Re: FRM-41003: "This function cannot be performed here" [message #607136 is a reply to message #607135] Mon, 03 February 2014 03:15 mist598 Messages: 1157Registered: February 2013 Location: Hyderabad Senior Member Quote:personally I would have added a go_block statement to move the cursor to the block you wanted to execute a query
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.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://www.orafaq.com/forum/t/191386/ VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=FRM-41003 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout 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
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript https://community.oracle.com/thread/3673537 enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn https://www.experts-exchange.com/questions/20613236/Create-an-Oracle-Forms-data-block-using-a-stored-procedure.html JavaScript back on and reload this page. Please enter a title. You can not post a blank oracle error 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 oracle error 41003 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
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 oth