use
RAISE exception_name;RAISE_APPLICATION_ERROR (
num BINARY_INTEGER,
msg VARCHAR2,
keeperrorstack BOOLEAN DEFAULT FALSE);
see examples at
http://www.promemoria.net/oreilly/books/oracle/langpkt/ch01_10.htm
RAISE exception_name;RAISE_APPLICATION_ERROR (
num BINARY_INTEGER,
msg VARCHAR2,
keeperrorstack BOOLEAN DEFAULT FALSE);
see examples at
http://www.promemoria.net/oreilly/books/oracle/langpkt/ch01_10.htm
解决方案 »
- 关于聚合函数max和distinct
- 请问在oracle中,如何将查询结果替换?
- 求一个SQL语句
- 请教各位大虾:ORACLE中删除表引起的碎片问题?
- 请教关于 控制台 Enterprise Manager Console 的一些问题 大家快来呀
- 在VFP中连接Oracle,难道除了在本机安装Oracle客户端,就真的别无他法了吗?
- 为什么在ORACLE的OMC中找不到"数据库"这个树节点
- 如何选取表中指定的行???急!!!
- oracle8.17在windows2000server启动失败,求救!
- 数据库 Oracle pl/sql 登录不了
- 怎么样将两个表(有相关联的关键字)产生联系??(用什么可视化的工具)
- Oracle8的简单问题。
http://www.promemoria.net/oreilly/books/oracle/bipkt/ch01_03.htmPROCEDURE DBMS_STANDARD.RAISE_APPLICATION_ERROR
(num BINARY_INTEGER
,msg VARCHAR2
,keeperrorstack boolean default FALSE);
Raises PL/SQL exception num, together with text msg from a stored program. The error can be placed together with any other errors on the error stack. If keeperrorstack is set to TRUE, default behavior is to replace the error stack with this single exception. ===============================================================
The explanation seems to be contrary to what I think it should be, :-)