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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create trigger command does "nothing"-good or bad 1

Status
Not open for further replies.

deehowe

Programmer
Oct 10, 2001
3
US
Any create trigger command that I enter in pl/sql ignores
my attempts to create the trigger. No syntax error, no
creation, no message. It just keeps feeding me command
prompts until I hit control <C>. For example, two
PL/SQL sessions follow:

SQL> create trigger;
2 ;
3 ;
4

SQL> create trigger trigtest
2 before insert on purchaseorder
3 for each row
4 begin
5 -- Nothing
6 end;
7 ;
8 ;
9

Any advice?
 
Try using a slash:

SQL> create trigger trigtest
2 before insert on purchaseorder
3 for each row
4 begin
5 NULL;
6 end;
7 ;
8 /
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top