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

Home -> Community -> Usenet -> c.d.o.server -> Can't create a trigger on table i created

Can't create a trigger on table i created

From: <harkinj_at_my-deja.com>
Date: Fri, 25 Aug 2000 16:31:51 GMT
Message-ID: <8o671m$v0b$1@nnrp1.deja.com>

Hi,
I'm very new to Oracle so bare with me . I'm using Personal Oracle 8.0 on NT.

I've logged into my conf database using

connect internal/oracle_at_conf;

I've created a table named inventory .
When i attempt to create a trigger with the below coide in SQL Plus

CREATE OR REPLACE TRIGGER Create_Awf_Job  BEFORE UPDATE ON Inventory
 call CreateJob('http://johnh-p2-400/createnewjob.asp', '0XCF804840115111d48C6100104B71BD07', '0xF50517327A8E11D4A6CE00104B8D17A 2', 50, 10)

I get the following error.
ORA-04089: cannot create triggers on objects owned by SYS

How can i get the trigger created on the table?. I Think Internal is a user name created when i installed the product.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 11:31:51 CDT

Original text of this message

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