Using RAISE_APPLICATION_ERROR : raise_application_error « PL SQL Programming « Oracle PL/SQL Tutorial

Oracle PL/SQL Tutorial

1. Introduction

2. Query Select

3. Set

4. Insert Update Delete

5. Sequences

6. Table

7. Table Joins

8. View

9. Index

10. SQL Data Types

11. Character String Functions

12. Aggregate Functions

13. Date Timestamp Functions

14. Numerical Math Functions

15. Conversion Functions

16. Analytical Functions

17. Miscellaneous Functions

18. Regular Expressions Functions

19. Statistical Functions

20. Linear Regression Functions

21. PL SQL Data Types

22. PL SQL Statements

23. PL SQL Operators

24. PL SQL Programming

25. Cursor

26. Collections

27. Function Procedure Packages

28. Trigger

29. SQL PLUS Session Environment

30. System Tables Data Dictionary

31. Object Oriented

32. XML

33. Large Objects

34. Transaction

35. User Privilege

Microsoft Office Word 2007 Tutorial

Java

Java Tutorial

Java Source Code / Java Documentation

Java Open Source

Jar File Download

Java Articles

Java Products

Java by API

C# / C Sharp

C# / CSharp Tutorial

ASP.Net

JavaScript DHTML

JavaScript Tutorial

JavaScript Reference

HTML / CSS

HTML CSS Reference

C / ANSI-C

C Tutorial

C++

C++ Tutorial

PHP

Python

SQL Server / T-SQL

Oracle PL / SQL

PostgreSQL

SQL / MySQL

MySQL Tutorial

VB.Net

VB.Net Tutorial

Oracle PL/SQL Tutorial » PL SQL Programming » raise_application_error

24. 15. 1. Using RAISE_APPLICATION_ERROR

SQL> SQL> CREATE OR REPLACE PROCEDURE Register is 2 BEGIN 3 RAISE_APPLICATION_ERROR(-20000, 'Can''t add more Employee'); 4 5 EXCEPTION 6 WHEN NO_DATA_FOUND THEN 7 RAISE_APPLICATION_ERROR(-20001, ' doesn''t exist!'); 8 END Register; 9 / Procedure created. SQL> SQL> call Register(); call Register() * ERROR at line 1: ORA-20000: Can't add more Employee ORA-06512: at "JAVA2S.REGISTER", line 3 SQL>

24. 15. raise_application_error
24. 15. 1. Using RAISE_APPLICATION_ERROR
24. 15. 2. Raise applocation error

w_w__w_._j_a_va_2s.com___ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.