http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FPL_SQL_Programming%2FError
Oracle PL/SQL Tutorial/PL SQL Programming/Error - История изменений
2026-04-07T00:59:26Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/PL_SQL_Programming/Error&diff=4049&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/PL_SQL_Programming/Error&diff=4050&oldid=prev
Admin: 1 версия
2010-05-26T10:08:29Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Display error==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> set serveroutput on<br />
SQL><br />
SQL> create or replace procedure proc0 is<br />
2 begin<br />
3 RAISE no_data_found;<br />
4 end;<br />
5 /<br />
Procedure created.<br />
SQL><br />
SQL><br />
SQL> create or replace procedure proc1 is<br />
2 begin<br />
3 NULL;<br />
4 dbms_output.put_line ("calling proc0");<br />
5 proc0;<br />
6 EXCEPTION<br />
7 WHEN OTHERS THEN RAISE DUP_VAL_ON_INDEX;<br />
8 end;<br />
9 /<br />
Procedure created.<br />
SQL><br />
SQL> create or replace procedure proc2 is<br />
2 begin<br />
3 dbms_output.put_line ("calling proc1");<br />
4 proc1;<br />
5 EXCEPTION<br />
6 WHEN OTHERS THEN RAISE value_error;<br />
7 end;<br />
8 /<br />
Procedure created.<br />
SQL><br />
SQL><br />
SQL> create or replace procedure proc3 is<br />
2 begin<br />
3 dbms_output.put_line ("calling proc2");<br />
4 proc2;<br />
5 end;<br />
6 /<br />
Procedure created.<br />
SQL><br />
SQL><br />
SQL> BEGIN<br />
2 proc3;<br />
3 END;<br />
4 /<br />
calling proc2<br />
calling proc1<br />
calling proc0<br />
BEGIN<br />
*<br />
ERROR at line 1:<br />
ORA-06502: PL/SQL: numeric or value error<br />
ORA-06512: at "sqle.PROC2", line 6<br />
ORA-00001: unique constraint (.) violated<br />
ORA-06512: at "sqle.PROC1", line 7<br />
ORA-01403: no data found<br />
ORA-06512: at "sqle.PROC3", line 4<br />
ORA-06512: at line 2<br />
<br />
SQL></source><br />
<br />
<br />
<br />
== Get error information: SQLCODE, SQLERRM==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> CREATE OR REPLACE PROCEDURE getErrorInfo (<br />
2 errcode OUT INTEGER,<br />
3 errtext OUT VARCHAR2)<br />
4 IS<br />
5 c_keyword CONSTANT CHAR(23) := "java.sql.SQLException: ";<br />
6 c_keyword_len CONSTANT PLS_INTEGER := 23;<br />
7 v_keyword_loc PLS_INTEGER;<br />
8 v_msg VARCHAR2(1000) := SQLERRM;<br />
9 BEGIN<br />
10 v_keyword_loc := INSTR (v_msg, c_keyword);<br />
11 IF v_keyword_loc = 0<br />
12 THEN<br />
13 errcode := SQLCODE;<br />
14 errtext := SQLERRM;<br />
15 ELSE<br />
16 errtext := SUBSTR (<br />
17 v_msg, v_keyword_loc + c_keyword_len);<br />
18 errcode :=<br />
19 SUBSTR (errtext, 4, 6 /* ORA-NNNNN */);<br />
20 END IF;<br />
21 END;<br />
22 /<br />
SP2-0804: Procedure created with compilation warnings<br />
SQL><br />
SQL><br />
SQL> show error<br />
Errors for PROCEDURE GETERRORINFO:<br />
LINE/COL ERROR<br />
-------- -----------------------------------------------------------------<br />
3/4 PLW-07203: parameter "ERRTEXT" may benefit from use of the NOCOPY<br />
compiler hint<br />
SQL><br />
SQL></source></div>
Admin