Oracle Error 20301
Contents |
Organic Keywords 1-3 position ora -00936 error in oracle 4-100 position 0 0 The look oracle error codes list with description of ora-20301.ora-code Keywords Analytic Sorry. Probably, ora-20301.ora-code doesn't have oracle error sqlcode shut keywords. If it was your competitors - good for you :) Please, check out
Oracle Error Codes Table
other websites below. Diagram of Position Position Organic Keywords Competitors for ora-20301.ora-code Website Not found Press About ora-20301.ora-code Overview Keywords Analytic Diagram of Positions Competitiors Press About Updated websites moyea.com oracle error codes and solution mygreatphone.com thinstallsoft.com kigo-video-converter.com joebuddentv.com online-television.tv cellularabroad.com spiritjb.org globalearntalk.com asian-sirens.com Popular ShutKeywords hvac calculator iphon best wordpress mu plugins biathlon sprint vb6 counting lines of code hello dolly wordpress nds 3d roms download utorrent download tomtom for huawei zion lan card lan phudi code naruto emoticons for facebook Latest queries nipple slips and see through pictures raging waters water slides cute school screensavers hurrydate case ppt css font tester ctios army hvrsd faber renten lotto design your own bridesmaid dress conto alla rovescia About Terms Contacts Copyright © 2011, Shutkeys
and other oracle error 1 troubleshooting information in these books. List of Message Types
Oracle Error Handling
ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to
Oracle 11g Error Codes
ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249 http://shutkeys.net/ora-20301.ora-code.com ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
vid Type in oracle error text* *e.g.username (at oracle error codes least 3 characters long) ora amd aud dbv drg epc exp img imp kup lcd lfi lpx lrm lsx mod ncr nid nmp nnc nnf nnl nno npl nze o2f o2i o2u pcb pcc pcf pls qsm rman sql sql*loader tns vid Error type information..... Search tips..... Oracle Support Copyright © Ora-error 2004-2012, all rights reserved.
easiest fix would be is to handle the error in the PL/SQL block, When a SQL statement is written within a PL/SQL block, enclose the SQL with a BEGIN and END statement. Handle the exception and raise a user-friendly message or handle the rest of the processing. Eg: CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; END; / The above procedure has not handled the error that would be raised if the select statement did not find the specified empno. See the following for the error raised: SQL> exec test_proc (1) begin test_proc (1); end; * ERROR at line 1: ORA-01403: no data found ORA-06512: at "TAROT.TEST_PROC", line 4 ORA-06512: at line 1 If you want the procedure to execute properly without errors on the screen, then you would have to handle the error. The Exception needs to be controlled by adding an exception handler to the code. The above code has been modified to handle an exception NO_DATA_FOUND. This is the name of the exception that the error relates to. CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; EXCEPTION WHEN NO_DATA_FOUND THEN INSERT INTO empresult values(p_empno, 'Did not find Sarah Jones'); END; / If you execute the above procedure now, this is what you would see: SQL> exec test_proc (1) PL/SQL procedure successfully completed. SQL> select * 2 from empresult; EMPNO EMPNAME --------- -------------------------------------------------- 1 Did not find Sarah Jones As the exception was handled, a row was inserted into the empresult table with the error message you specified. When the exception is raised, the control jumps from the select statement to the exception handler routine. Any code after the Select will not get executed if an exception has been raised. But if you do have some code that needs to be executed after the select has been executed, irrespective of whether the select was successful or not, then you would need to nest the begin and end statements. CREATE OR REPLACE PROCEDURE test_proc (p_empno IN NUMBER) IS l_empname VARCHAR2(50); l_count NUMBER; BEGIN BEGIN SELECT empname INTO l_empname FROM emp WHERE empno = p_empno; IF l_empname = 'Sarah Jones' THEN INSERT INTO empresult values ('105', 'Found Sarah Jones'); END IF; EXCEPTION WHEN NO_DATA_FOUND TH