Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Triggers in SQL plus or toad
I created a spl script that creates my DB. I run the script with the @
command from my sql plus prompt. At first it consists of only create
table and sequence commands. But after I put in create trigger
commands it crashes.
When I use / after my triggers, it still doesn't work.
Can somebody pls help me?
Here is an example of my script file:
DROP TABLE LA_HARDWARE_DEVICE;
CREATE TABLE LA_HARDWARE_DEVICE (
LA_HARDWARE_DEVICE_PK NUMBER primary key,
NAME VARCHAR2(20), DESCRIPTION VARCHAR2(4000) , IP_ADDRESS VARCHAR2(15), COMPORT VARCHAR2(6), LA_THIN_CLIENT_GUID VARCHAR2(32) , TYPE SMALLINT, USER_STAMP VARCHAR2(10), LAST_UPDATE TIMESTAMP, IS_VALID NUMBER(1,0)
GUID VARCHAR2(32) , NAME VARCHAR2(20) , DESCRIPTION VARCHAR2(4000) , IP_ADDRESS VARCHAR2(15) , USER_STAMP VARCHAR2(10) , LAST_UPDATE TIMESTAMP , IS_VALID NUMBER(1,0)
I tried to run it in toad, still doesn' t work, copy pasting the code doesn't work Received on Thu Oct 28 2004 - 08:50:46 CDT