P.S : I need INSTED-OF triggers enabling immediately
Thanks in adv
08-26-2003, 06:53 AM
AFAIK You need to have Enterprise edition installed to use Instead-Of triggers.
By the looks of your options you have standard version installed.
08-26-2003, 07:10 AM
it is 8i ee not std ..
Any more suggestions ?
08-26-2003, 07:22 AM
Can you show the output from the following
SELECT * FROM v$version;
08-26-2003, 07:27 AM
Kindly check the following
Oracle8i Release 22.214.171.124.0 - Production
PL/SQL Release 126.96.36.199.0 - Production
CORE Version 188.8.131.52.0 - Production
TNS for 32-bit Windows: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.0 - Production
08-26-2003, 07:42 AM
Yep, it should read
Oracle8i Enterprise Edition Release 18.104.22.168.0 - Production
08-26-2003, 08:04 AM
As Tomazz said (and I initally noted) you are using the standard version NOT enterprise edition.
You will need to upgrade to EE to take advantage of the features your want.
08-26-2003, 09:01 AM
Ya..that's right. You need to upgrade to EE and here u will have more options than the standard one. Have seen most of the features are enabled in EE version than standard but database size requirement could be a bottleneck.