Error Code 40350
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta on-error trigger in oracle forms example Discuss the workings and policies of this site About Us Learn
How To Display Error Message In Oracle Forms
more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Frm-40301 Query Caused No Records To Be Retrieved
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,
Query Caused No Records To Be Retrieved In Oracle Forms
helping each other. Join them; it only takes a minute: Sign up Forms Suppress Error Message And Catch frm-40350 up vote 2 down vote favorite I have the following code on a button's WHEN-BUTTON-PRESSED trigger BEGIN SYNCHRONIZE; populate_maximo_records; END; There will be a scenario that there will not be any records ti populate in block. If there how to display message in oracle forms 10g are no records, currently it is throwing the following error message frm-40350 query caused no records to be retrieved Instead, I would like to suppress the above message and display a customized message. How can I do this? oracle oracleforms share|improve this question edited Mar 5 '14 at 10:23 asked Mar 5 '14 at 8:19 user75ponic 5,85332116207 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted You can use system.message_level to suppress messages from the system: You have levels of messages: 0, 5, 10, 15, 20, 25, >25 In a trigger, you can specify that only messages above a specified severity level are to be issuedby the form. You do this by assigning a value to the MESSAGE_LEVEL example: declare old_message_level number; begin :old_message_level := :system.message_level; :system.message_level := 20; -- suppresses most errors commit; -- action you want to do without messages or errors :system.message_level := old_message_level; end; If you hold any errors occurring in a variable or in a table you then sho
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design oracle forms error handling and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware system.message_level in oracle forms 10g Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker oracle on-error trigger JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat bluesguyAZ59 iudithm COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All http://stackoverflow.com/questions/22192151/forms-suppress-error-message-and-catch-frm-40350 Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Development A forum where peers share technical expertise, solve problems, and discuss issues related to Oracle Development. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/frm40350-query-caused-no-records-to-be-retrieved-1005538 Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. FRM-40350 "Query caused no records to be retrieved" dipesh.mistry asked May 5, 2006 | Replies (4) Hi everyone, I am using Oracle Forms 6i and we have developed a custom form to talk with Oracle Applications. I would want to know if we can customize the standard error message for error FRM-40350 : Query caused no records to be retrieved. If yes, then what trigger should be used and how it can be implemented? Regards, Dipesh =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently dele
Music Digital Photography & Video Games & Strategy Guides Project Management Mobile & Wireless Computing Education & Reference Encyclopedias Test Preparation Studying & Workbooks Schools & Teaching Writing, Research & Publishing Guides Foreign Language Study & http://flylib.com/books/en/1.587.1.49/1/ Reference Atlases & Maps Dictionaries & Thesauruses Words, Language & Grammar College & University Trivia & Fun Facts Consumer Guides Business & Investing Industries & Professions Management & Leadership Organizational Behavior Personal https://www.oraexcel.com/oracle-12cR1-ORA-40350 Finance Small Business & Entrepreneurship Popular Economics Marketing & Sales Finance Skills Business Life Economics Job Hunting & Careers Biography & History Reference International Real Estate Investing Women & Business Science & oracle forms Math Mathematics Technology Reference Earth Sciences Physics Biological Sciences Behavioral Sciences Nature & Ecology Astronomy & Space Science History & Philosophy Experiments, Instruments & Measurement Agricultural Sciences Category list Computers & Technology Programming Software Design, Testing & Engineering Software Development Software Networking Networks, Protocols & APIs Databases Relational Databases Education & Reference Similar pages PLL ErrorsTWO FORMS OF PEER-BASED ORGANIZATIONS6.6 Subclassing Built-in ClassesThe Role in oracle forms of XMLHandling Web Service FailureSection 160. Handle Junk MailSection 0.4. Why Study Programming?What About the Key Success Factors?MDB Best PracticesChapter 17 TriggersWhat Is a Trigger?Configuring Your ApplicationHack 92 Handle Transaction Errors within the API WrapperDigitizing Logged Clips Handling Errors Buy on amazon.com >> Lakshman B. << Previous page Table of contents Next page >> Handling Errors Now you will learn how to handle errors raised by each of the four categories. FORM_SUCCESS and FORM_TRIGGER_FAILURE Either the FORM_SUCCESS built-in or the FORM_TRIGGER_FAILURE exception must be used to handle all Forms errors. FORM_SUCCESS is a Boolean function that evaluates to TRUE or FALSE depending on the success or failure of a Forms built-in. FORM_TRIGGER_FAILURE is an exception that has to be raised to stop further processing whenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling. Suppressing Errors Using ON-ERROR and ON-MESSAGE Triggers The two triggers ON-ERROR and ON-MESSAGE can be used to suppress unnecessary messages of both error and informative types. Here, I will elaborate on the examples discussed earlier in the Error Type section. Consider the following informative-type error messages: FRM-
_Font family, color, and size _Custom cell format _Horizontal and vertical alignment _Bold, italic, and underline _Borders with styles and colors _Merge and align cells _Wrap text _Column width and row height _Multiple sheets _Multiple documents _Export from select _Add 1.048.576 rows to sheet _Save worksheet to XLSX file _Save worksheet to BLOB _Set sheet paper size _Left and right text indent _Unlimited sheets per document _Set cell background color _Set column width _Set row height _Set sheet margins _Set sheet header and footer text _Set cell comment _Filter cells _Rotate text _Hide columns and rows _Set column formulas _Set sheet portrait or landscape _Set cell as hyperlink _Group columns _Save BLOB to file _Freeze panes vertical _Freeze panes horizontal _Cell style _Set document author _Set date system _Read xlsx document _Set active cell _List - data validation _Whole number - data validation _Decimal number - data validation _Date - data validation _Time - data validation _Text length - data validation Documentation add_sheet add_row query_to_sheet set_row_height set_cell_value set_cell_font set_default_font set_cell_bold set_cell_italic set_cell_underline set_cell_color set_cell_bg_color set_cell_align_left set_cell_align_right set_cell_align_center set_cell_vert_align_top set_cell_vert_align_middle set_cell_vert_align_bottom set_column_width set_cell_border_top set_cell_border_bottom set_cell_border_left set_cell_border_right set_cell_border set_cell_wrap_text merge_cells merge_rows set_cell_format set_cell_formula set_cell_rotate_text set_sheet_margins set_sheet_landscape set_sheet_paper_size set_sheet_header_text set_sheet_footer_text set_cell_hyperlink set_cell_indent_left set_cell_indent_right set_cell_comment hide_column hide_row set_cells_filter save_to_file save_to_blob set_1904_date_system set_1900_date_system set_document_author add_style set_cell_style freeze_panes_horizontal freeze_panes_vertical blob_to_file group_columns set_cell_validation_list set_cell_validation_integer set_cell_validation_decimal set_cell_validation_date set_cell_validation_time set_cell_validation_text_len Resources FAQ Privacy About Us Contact Us Oracle Database Error Code ORA-40350 Description Database: 12c Release 1 Error code: ORA-40350 Description: One or more models exist that cannot be downgraded Cause: There are