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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- mnewsrx
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Creating a Trigger and using SEQUENCE
Karluk, Thank you very much. It worked this time. Thanks again.- mnewsrx
- Post #7
- Forum: Oracle: All versions
-
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- mnewsrx
- Post #6
- Forum: Oracle: All versions
-
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...- mnewsrx
- Post #3
- Forum: Oracle: All versions
-
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...- mnewsrx
- Thread
- Replies: 6
- Forum: Oracle: All versions
