VACOLS VM Trigger Fix M1

Download and follow the instructions below VACOLS_VM_trigger_fix_M1.zip

ON THE VACOLS VM:

1. Log in to VACOLS VM (password is password)
2. Open a command prompt (search ‘cmd’ from start menu)
3. Type ‘sqlplus / as sysdba’ to run the SQL*Plus command line utility
4. In SQL*Plus, run the following SQL command:
   1. GRANT CREATE TRIGGER TO VACOLS_TEST;
   2. Don’t forget the semicolon at the end!
   3. You should see “Grant succeeded” after running the command
   4. You can leave this open for the last steps

ON YOUR LOCAL MACHINE: 5. Open SQLDeveloper and create a new connection to the VACOLS DB with the following settings: 1. Name: vacols_test 2. Username: VACOLS_TEST 3. Password: VACOLS_TEST 4. Hostname: localhost 5. Port: 1521 6. SID: BVAP 6. After saving the connection, find it in “Connections” window on the left side of the program and click the “+” to connect and expand it 7. Expand the “Triggers” folder 8. For each trigger: 1. Click to open it in the editor 2. Replace all of the code for the trigger with the code from the associated file 3. Save the file 4. Verify that the “messages” window that pops up at the bottom of the screen says “Compiled” and does not say with errors

ON THE VACOLS VM (again): 9. If you closed SQLPlus, follow steps 1-3 to open it again 10. In SQLPlus, run the following SQL command: 1. REVOKE CREATE TRIGGER FROM VACOLS_TEST; 2. Don’t forget the semicolon at the end! 3. You should see “Revoke succeeded” after running the command 11. Type ‘exit’ to exit SQL*Plus and close the command prompt