Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mnewsrx

  1. mnewsrx

    Another Trigger Problem

    I am new to Oracle and continue to have problems creating triggers. I am using the OE schema and Oracle product_information table to get experience with triggers. I want to create a trigger on the Product_Information table that fires on the update of the table. The trigger should not allow a...
  2. mnewsrx

    Creating a Trigger and using SEQUENCE

    Karluk, Thank you very much. It worked this time. Thanks again.
  3. mnewsrx

    Creating a Trigger and using SEQUENCE

    No, that did not work as well. I get the same 2 errors: 2/1 SQL Statement Ignored 2/39 Invalid user.table.column, table.column or column specification Here are my columns for Product: ProductID, Name, ListPrice, Category Here are my columns for Events: EventID, ProductID, UserUpdating, EventTime
  4. mnewsrx

    Creating a Trigger and using SEQUENCE

    Thank you for your assistance. I reran the code exactly as you have it and got the same errors. The table Product has 4 columns(ProsuctID, Name, ListPrice, Category). I have entered 5 rows of data in the Product table. The table Events has 4 columns (EventID, ProductID, UserUpdating...
  5. mnewsrx

    Creating a Trigger and using SEQUENCE

    I am having problems with a PL/SQL oracle program. I am trying to invoke a trigger before UPDATE ON table Product and insert the trigger messages into the table Events. Both Product and Events tables have been created. Also, the sequence has been created. Here's my code below: CREATE OR...
See more

Part and Inventory Search

Back
Top