Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.6 Bug - statement level triggers

8.1.6 Bug - statement level triggers

From: Leng Kaing <leng.kaing_at_hancorp.com.au>
Date: Wed, 7 Jun 2000 15:24:44 +1000
Message-Id: <10520.108001@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_000_01BFD040.B0825DA2


Content-Type: text/plain



Hello everyone,



If you're on Oracle 8.1.6 (any o/s will do) can you please try this and let
me know if it's causing the same error as I'm encountering.



 <<trig.sql>> 


Essentially the scenario is this:

1. table SB1 is the parent of SB2
2. There are statement level triggers on both tables
3. If the statement level trigger on both tables are enabled, and I issue


the statement DELETE * FROM SB1;, the client get ORA-3113. A trace file is
generated in the udump area with the following dump:



Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object),
addr: 0x90, PC: kglpnp()+92


*** 2000-06-06 15:27:11.280


ksedmp: internal or fatal error


ORA-07445: exception encountered: core dump [kglpnp()+92] [SIGSEGV] [Address
not mapped to object] [144] [] []


Current SQL statement for this session:




If the statement level triggers on SB2 are disable, the delete statement is
processed without any errors.



I've tried the same scenario on 8.0.5 and it is ok. But the errors are there
on 8.1.6.1.1.0 and 8.1.6.0.0.



Thanks,



> Leng.

> -----------------

> Leng Kaing

> Tel: +61-3-9843-8440

> Email: leng.kaing_at_hancorp.com.au

> 




------_=_NextPart_000_01BFD040.B0825DA2


Content-Type: application/octet-stream;


        name="trig.sql"


Content-Disposition: attachment;


        filename="trig.sql"



set echo on


spool trig.out


DROP TABLE SB1 CASCADE CONSTRAINTS ; 


CREATE TABLE SB1 ( 



  PKEY  NUMBER        NOT NULL, 



  PRIMARY KEY ( PKEY ) ) ; 


CREATE OR REPLACE TRIGGER sb1_ad after delete on sb1
begin


dbms_output.put_line ('sb1 : after delete') ;
end ;


/



CREATE OR REPLACE TRIGGER sb1_adr after delete on sb1
for each row


begin


dbms_output.put_line ('sb1 : after delete (row)') ;
end ;


/



CREATE OR REPLACE TRIGGER sb1_bdr before delete on sb1
for each row


begin


dbms_output.put_line ('sb1 : before delete (row)') ;
end ;


/



CREATE OR REPLACE TRIGGER sb_bd before delete on sb1
begin


dbms_output.put_line ('sb1 : before delete') ;
end ;


/



DROP TABLE SB2 CASCADE CONSTRAINTS ; 


CREATE TABLE SB2 ( 



  PKEY      NUMBER        NOT NULL, 



  SB1_PKEY  NUMBER, 



  PRIMARY KEY ( PKEY ) ) ; 


ALTER TABLE SB2 ADD  CONSTRAINT FK_SB1_SB2

 FOREIGN KEY (SB1_PKEY) 



  REFERENCES SB1 (PKEY) 



 ON DELETE CASCADE;


CREATE OR REPLACE TRIGGER sb2_ad after delete on sb2
begin


dbms_output.put_line ('sb2 : after delete') ;
end ;


/



CREATE OR REPLACE TRIGGER sb2_adr after delete on sb2
for each row


begin


dbms_output.put_line ('sb2 : after delete (row)') ;
end ;


/



CREATE OR REPLACE TRIGGER sb2_bd before delete on sb2
begin


dbms_output.put_line ('sb2 : before delete') ;
end ;


/



CREATE OR REPLACE TRIGGER sb2_bdr before delete on sb2
for each row


begin


dbms_output.put_line ('sb2 : before delete (row)') ;
end ;


/



insert into sb1 (pkey) values (10) ;



insert into sb2 (pkey, sb1_pkey) values (100, 10) ;



commit ;



spool off



------_=_NextPart_000_01BFD040.B0825DA2--







 From: "Gurgaon, DBA (CAP, GECSI, CONTRACTOR)" <DBA.Gurgaon_at_geind.GE.com>
 Date: Wed, 7 Jun 2000 11:09:46 +0530 


 Subject: RE: Dropping a database under unix



Go to that particular directory by cd <dirname>.
ls -l to check the contents of dir.


rm -i <filename> to remove particular file from that dir.
Before this check for the location of these files from your database.
 


Vikas



-----Original Message-----


From: Mr. Majestic [mailto:rc_at_neomenia.com]
Sent: Wednesday, June 07, 2000 10:54 AM


To: Multiple recipients of list ORACLE-L
Subject: Dropping a database under unix




How do I do this Under svrmgrl on a Solaris? My initial databse wasn't
propery created and I need to go back and recreate it. 
 


I know you have to remove its datafiles, redo log files, and all other
associated files (control files, parameter files, archived log files).
 


But I don't know how it's done under unix.
 


ThanksI, new to unix 


Student








 From: Vipul Mukund Shah <vipul.shah_at_almarai.com>
 Date: Wed, 7 Jun 2000 08:42:11 +0300 


 Subject: RE: Mailing List



Hi Bruce



I am sorry for sending the wrong email address  to pallav next time I will
see to it that I am correct. After sending mail I realized that I had send
wrong email. so I had send personal message to pallav mentioning the site
name www.odtug.com <http://www.odtug.com> . I again apolozie for sending
wrong email address to pallav.



Regards,


Vipul


	-----Original Message-----
	From:	Bruce Bergman [SMTP:bbergman_at_BridgeMedical.com]
	Sent:	Tuesday, June 06, 2000 6:38 PM
	To:	'oracle-l_at_fatcity.com'
	Cc:	'vipul.shah_at_almarai.com'; 'pallav_at_starmedia.net'
	Subject:	Re: Mailing List

	Vipul,

	The mailing list you mentioned is for Developer 2000 topics, hence
the name
	"-DEV2K".  Perhaps you meant to tell Pallav of the more appropriate
mailing
	list named ODTUG-SQLPLUS-L, which covers PL/SQL in addition to
SQL*Plus
	topics.

	Also, you cannot join a mailing list by sending mail to the list
itself.
	All that happens is that your message is rejected and returned to
you.  The
	correct instruction to join a mailing list is send an E-mail to:

	    ListGuru_at_fatcity.com

	And in the message BODY, put:

	    SUB ODTUG-SQLPLUS-L Pallav Kalva

	That will get you on the list.  Vipul, please check your facts
before
	posting incorrect information, as it causes a lot of people to get
confused
	and ultimately ask me for help anyhow.

	thanks,
	bruce
	ListMaster_at_fatcity.com


	-------Original Message----------

	 From: Vipul Mukund Shah <vipul.shah_at_almarai.com>
	 Date: Tue, 6 Jun 2000 08:25:48 +0300 
	 Subject: RE: Mailing List

	Hi Pallav

	send a subscription mail to ODTUG-DEV2K-L_at_fatcity.com
	<mailto:ODTUG-DEV2K-L_at_fatcity.com> 

	Regards,
	VMS

		-----Original Message-----
		From:	Pallav Kalva [SMTP:pallav_at_starmedia.net]
		Sent:	Tuesday, June 06, 2000 12:58 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Mailing List

		Hi, 

		   Does anyone know any good mailing lists for Oracle PL/SQL
	developers ??
		If so, can you please send me the url.


Received on Wed Jun 07 2000 - 00:24:44 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US