| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiple Database Triggers on 7.1.4 under SCO
Anshal,
I had this problem last week, but managed to solve it by including the COMPATIBLE=7.1.0 in the init.ora and restarting the database. We are on HP9000/HP-UX running O7.1.6. You may want to check whether this init.ora change has taken effect by querying v$parameter. select * from v$parameter where name like 'compatible%';
NUM NAME TYPE VALUE ISDEFAULT
---------- -------------------- ---------- ---------- ---------
69 compatible 2 7.1.0 FALSE
Probably its a port-specific bug, if this doesn't work for you.
Sridhar Subramaniam
Telstra Corporation
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au
avion_at_ozemail.com.au
From: owner-oracle-l
To: Multiple recipients of list ORACLE-L
Subject: Multiple Database Triggers on 7.1.4 under SCO
Date: Friday, 29 December 1995 11/05PM
Hi Oracle Wizards,
Can someone please let me know how to allow creation of multiple Triggers on
tables.
We have added COMPATIBLE = 7.1.0 in init.ora file but it has proved to be of
no
use.
We are running Oracle 7.1.4 under SCO UNIX ODT 3.0
Thanks in advance
Anshal
 |
 |