Oracle Error Code 100
Contents |
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 message. Please type your
Sql Error Code 100
message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and sqlcode 100 ora 01403 SQL This discussion is archived 7 Replies Latest reply on Jan 11, 2012 1:03 PM by Billy~Verreynne sqlcode 100 does not come
Ora-100
with exception 862792 Jan 11, 2012 10:43 AM I have following query SELECT a.col1 into v_acc_account FROM account_t a WHERE a.col1= FOR UPDATE OF a.col1 NOWAIT; The statement returns sqlcode of 100 and does not ora-00100 throw exception From oracle documentation I understand that the errorcode is accompanied by an exception. What may be the reason behind this behavior. The return code 100 explains 'DATA NOT FOUND", we have data for the select query. Data not found means, the select is failing or the locks not available. any help much appreciated Regards, Nandish I have the same question Show 0 Likes(0) 3290Views Tags: none (add) 100Content tagged with 100, sql server error 100 dbContent tagged with db, deadlocksContent tagged with deadlocks, exceptionsContent tagged with exceptions, locksContent tagged with locks, oracleContent tagged with oracle, sqlcodeContent tagged with sqlcode This content has been marked as final. Show 7 replies 1. Re: sqlcode 100 does not come with exception BluShadow Jan 11, 2012 11:00 AM (in response to 862792) Do you have an exception handler in your code, or in the code that calls that code anywhere? Perhaps a WHEN OTHERS THEN NULL exception handler or some other such thing? Like Show 0 Likes(0) Actions 2. Re: sqlcode 100 does not come with exception €$ħ₪ Jan 11, 2012 11:04 AM (in response to 862792) If you have When Others Clause remove and see the error If you getting an error code and nopt message may be a bug Like Show 0 Likes(0) Actions 3. Re: sqlcode 100 does not come with exception 862792 Jan 11, 2012 11:05 AM (in response to BluShadow) Thanks for that reply. I have the exception block but it was catching only 'resource_busy' exception. The first part of my query is answered. The next one is why am I getting error code of 100 when data is present. is this because its not able to get the lock?] Thanks, Nandish Like Show 0 Likes(0) Actions 4. Re: sqlcode 100 does
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About
Sqlca.sqlcode Powerbuilder
Us Learn more about Stack Overflow the company Business Learn more about hiring developers oracle sqlcode 0 or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is
Oracle Exception Sqlcode 100
a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it https://community.oracle.com/thread/2333826 works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Why Sqlcode 100 does not come with exception up vote 3 down vote favorite 1 I have following query in a PL\SQL procedure on Oracle 10.2: This is the code LOOP BEGIN SELECT a.poid_id0 into v_acc_account_poidid0 FROM account_t a WHERE a.poid_id0=i_acct_id0 FOR UPDATE OF a.poid_id0 NOWAIT; EXIT http://dba.stackexchange.com/questions/10508/why-sqlcode-100-does-not-come-with-exception WHEN sqlcode = 0; EXCEPTION WHEN resource_busy THEN BEGIN v_max_retry_times_counter := v_max_retry_times_counter + 1 ; IF (v_max_retry_times_counter>v_max_retry_limit) THEN RAISE_APPLICATION_ERROR (ERROR_SELECTING,'Resource Busy with Nowait Option.',TRUE); EXIT; END IF; DBMS_LOCK.sleep(2); END; WHEN OTHERS THEN BEGIN RAISE_APPLICATION_ERROR (ERROR_SELECTING,'ORACLE ERROR DESCRIPTION'||sqlerrm ,TRUE); EXIT; END; END; END LOOP; The statement returns sqlcode 100 and does not throw an exception. From the Oracle documentation I understand that the error code is accompanied by an exception. What may be the reason behind this behaviour? The documentation says the error code 100 is DATA NOT FOUND; we have data for the select query. In this context does DATA NOT FOUND mean the select is failing or the lock is not available? Any help much appreciated. sql oracle exception locking share|improve this question edited Jan 13 '12 at 2:59 Andrew Russell 22837 asked Jan 11 '12 at 10:48 Nandish A migrated from stackoverflow.com Jan 11 '12 at 13:12 This question came from our site for professional and enthusiast programmers. Please specify which database. SQL Server? Oracle? MySQL? PostgreSQL? –Animesh Jan 11 '12 at 10:56 Oracle database. Updated the query –Nandish A Jan 11 '12 at 10:58 1 HOW did the statement return "sqlcode of
-100 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.dbasupport.com/forums/showthread.php?33022-Ora-100 click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: Ora -100 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-15-2003,03:21 AM #1 immacolato View Profile code 100 View Forum Posts Junior Member Join Date Mar 2002 Posts 5 Ora -100 When I open the application I have Oracle error code -100. What is this? Thank you Reply With Quote 01-15-2003,03:46 AM #2 SANJAY_G View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Singapore Posts 1,758 ORA-00100: no data found Cause: An application made reference to unknown or error code 100 inaccessible data. Action: Handle this condition within the application or make appropriate modifications to the application code. Note: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100. Sanjay G. Oracle Certified Professional 8i, 9i. "The degree of normality in a database is inversely proportional to that of its DBA" Reply With Quote 01-15-2003,05:17 AM #3 agasimani View Profile View Forum Posts Senior Member Join Date Feb 2001 Location UAE Posts 304 This is a general error, which says the data you are looking for is not found. These kind of errors can be traced only by debugging the application. Give some exercise to your brain and find it out yourself Agasimani OCP(10g/9i/8i/8) Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permission