🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #9175

Re: ʲô�б�㴥����������

#9175
From: ��ҲҪ����Ư��
Date: Fri, 29 Aug 2003 16:10
29 lines
2110 bytes
��3x

oracle����sqlдtrigger�ѵ���sql��׼�����
����ullman�Ľ̳���ı�׼sql��trigger��������
���DZ������

�������������ڣ����еĴ�����������һ���?����һ����û��������
������ô���£�

��λдһ��sql*plus��ͨ�ù�trigger������
��Ҫ����


�� �� XML (��~������) �Ĵ������ᵽ: ��
: Error:  ORA 4077  
: Text:   WHEN clause cannot be used with table level triggers  
: ----------------------------------------------------------------------------
: Cause:  The WHEN clause can only be specified for row-level triggers. 
: Action: Remove the WHEN clause or specify it for each row. 
: �� �� ordiple (��ҲҪ����Ư��) �Ĵ������ᵽ: ��
: : ����sql*plus�ﳢ�������ɸ�������
: : �����?
: : ORA-04077: WHEN �Ӿ䲻�����㴥����һ��ʹ��


--

�붽����ѧϰ
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.242.81.52]
Technical Details
Message-ID: <484KXG$ayf@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news-xfer2.atl.newshosting.com!63.218.45.10.MISMATCH!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.neu.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,45e627460fe59be9
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-08-29 09:13:05 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news-xfer2.atl.newshosting.com!63.218.45.10.MISMATCH!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.neu.edu.cn!SJTU
From: ordiple.bbs@bbs.sjtu.edu.cn (��ҲҪ����Ư��)
Newsgroups: cn.bbs.comp.database
Subject: Re: ʲô�б�㴥����������
Date: 29 Aug 2003 16:10:32 GMT
Organization: ��ˮ˼Դ
Message-ID: <484KXG$ayf@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1062173248.A
Lines: 29