Article View: cn.bbs.comp.database
Article #9175Re: ʲô�б�㴥����������
From: ��ҲҪ����Ư��
Date: Fri, 29 Aug 2003 16:10
Date: Fri, 29 Aug 2003 16:10
29 lines
2110 bytes
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 �Ӿ䲻�����㴥����һ��ʹ�� -- �붽����ѧϰ [m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.242.81.52][m
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!SJTUShow 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