Raise Application Error Recursive
Contents |
Tom Kyte � Last updated: April 02, 2009 - 6:22 pm UTC Category: Database � Version: 9.2.0.6 Whilst you are here, check out some content from the AskTom ora-00604 error occurred at recursive sql level 1 ora-20001 team: On Dynamic Sampling Latest Followup You Asked Hi Tom, Could you oracle after logon trigger tell me how to suppress "ORA-00604: error occurred at recursive SQL level 1" when I raise application error using oracle trigger raise application error "RAISE_APPLICATION_ERROR". I am using it in after logon trigger and restricting few users. I am displaying my error message. But I am getting the below errors also with my application error
Oracle Logon Trigger For Specific User
message. Is it possible to suppress the below error messages and want to display only the application error message. ******************************************************** 1)ORA-00604: error occurred at recursive SQL level 1 2)ORA-06512: at line 53 ******************************************************** Thanks, SC. and we said... you cannot, it works the way it works. Applications are responsible for displaying to end users what the application thinks is appropriate. This is oracle raise_application_error something your application would do - eg: put up a message box that says "login failed, sorry" SQLPlus displays the entire call stack because the developers of sqlplus felt that was most appropriate. You can have your applications display whatever you feel is appropriate. Reviews Write a Review Thanks July 26, 2006 - 3:16 pm UTC Reviewer: Sreekanth from Herndon, VA USA Thanks for the reply. It was useful to convince other people that it's not possible. One more question July 26, 2006 - 3:28 pm UTC Reviewer: S Tom, Thank you for your response. I have an other question. Could you pls tell me if it is possible to use dbms_output and display a message to the user in after logon trigger. The user can be logged in from sqlplus or any other tool. Followup July 26, 2006 - 4:14 pm UTC but sqlplus is pretty much the only tool that would get it - and sqlplus wouldn't even get it because it doesn't realize it would be there to be gotten. that and the logon trigger doesn't really work in the "
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 ora-20000 and reload this page. Please enter a title. You can
Ora-06512
not post a blank message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 1 2 Previous Next 26 Replies Latest reply on May 14, 2010 5:47 PM by 758325 https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:68817379083269 RAISE_APPLICATION_ERROR Gets ORA-06502 When Message is 198 Chars or More 758325 May 12, 2010 7:45 PM Hi, I'm seeing a problem in our 10.2.0.4 database where RAISE_APPLICATION_ERROR gets an ORA-06502: PL/SQL: numeric or value error: character string buffer too small error when a value of 198 characters or more is passed in the msg parameter. https://community.oracle.com/thread/1073652 The anonymous block below is an example of when the error occurs. DECLARE lv_error_msg VARCHAR2(4000) := NULL; BEGIN -- 198 char DOES NOT work. lv_error_msg := LPAD('$',198,'$'); IF (lv_error_msg IS NOT NULL) THEN RAISE_APPLICATION_ERROR(-20100,lv_error_msg); END IF; END; This is just a simple demo to show what's more or less happening in an application and not exact code used in the application. Does anyone know why this throw the ORA-06502 when I pass 198 characters or more? I should be able to pass a lot more than that. Thanks for any insight! Mike 2654Views Tags: none (add) ora-06502Content tagged with ora-06502, raise_application_errorContent tagged with raise_application_error This content has been marked as final. Show 26 replies 1. Re: RAISE_APPLICATION_ERROR Gets ORA-06502 When Message is 198 Chars or More Hoek May 12, 2010 8:03 PM (in response to 758325) No ORA-06502 here: SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE 10
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) http://searchoracle.techtarget.com/answer/Killing-the-session-through-an-AFTER-LOGON-trigger Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance raise application problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux raise application error Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q Killing the session through an AFTER LOGON trigger Sections Share this item with your network: Related Expert Q&A Error messages on attempting full export – SearchOracle Tracing activity performed by vendor – SearchOracle Trigger to restrict user after a certain number of ... – SearchOracle Sponsored News Predictable VDI Performance From PoC to Production –SimpliVity Hyper-Convergence Delivers Better Mission-Critical Performance –SimpliVity See More Vendor Resources Take Advantage of Oracle's 2 Day DBA Course –Oracle Corpor