#1
  1. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0

    Exclamation creating rules problems


    I'm trying to create rules on a table

    here's the rule:

    CREATE RULE audit AS ON INSERT TO studentmembers DO
    INSERT INTO staffmembers(name) VALUES('Joe')

    Its a stupid example but I keep getting the error message

    Invalid CREATE statement whenever I try to create any rule

    anyone know why?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,382
    Rep Power
    391
    Rules in Oracle? Where did you find that syntax?
  4. #3
  5. No Profile Picture
    almost there....
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    A Red Glitter Coffin
    Posts
    140
    Rep Power
    0
    My lecturer who doesn't have a clue what he's talking about, there is, of course, no rules in oracle.

    I have a problem with a trigger tho, please check out my 'Trigger compilation Error' Post!

IMN logo majestic logo threadwatch logo seochat tools logo