Re: Creating database triggers

From: Matthew M. Lih <matt.lih_at_trw.com>
Date: 1995/06/09
Message-ID: <3ra8fg$p4d_at_venice.sedd.trw.com>#1/1


In article <fkuyt.9.001480DF_at_iaehv.nl>, fkuyt_at_iaehv.nl (Frank Kuijten) says:
>
>In article <MARY.95Jun7120125_at_gulper.mitra.com> mary_at_mitra.com (Mary E. Hunt) writes:
 

>>Oracle 7.1.3 on Solaris 2.4
 

>>I am having a problem creating a database trigger. In the Server's
>>Application Developer's Guide it says you need the procedural option.
>>How do I know if I have the option installed, or how do I install it?
>>I don't see a specific product called Procedural Option in my
>>installer. Do I need to run some script in rdbms/admin? I tried
>>running the catproc.sql in rdbms/admin but a lot of the statements
>>were getting errors.
>

I just overcame a similar, if not identical problem.

Try executing the following three files as SYS user, in this order:

STANDARD.SQL
CATPROC.SQL
DBMSSTDX.SQL It's in the Installation Manual buried somewhere. It seems like if your installation bombed somewhere when it tried to create the database, these files won't get executed.

Hope this helps!

Matthew M. Lih
TRW DTD, SAIN Project
Software Lead Received on Fri Jun 09 1995 - 00:00:00 CEST

Original text of this message