Also, as a matter of practice the DBA’s have asked us to add the following items to our SQL scripts:
Set echo on
- Alter system set current_schema=<schema>
- The / for execution on triggers, procedures, etc
- Remember: DDL statements do an implicit commit
There is an example script right now for the 12.50 deploy too:
http://halpjira01:8080/secure/attachment/17446/promo_sql.txt
Example Section:
set echo on;
alter session set current_schema=WEB_OWNER;
<body of trigger would be here, etc.>
/
commit;