Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Trigger
I had a sql file that just had Creates for
tables/views. Then I tried to add a trigger.
I was using a jdbc connection to send the sql file to the database. That worked great until I added the trigger. I kept getting errors from oracle.
So I used to SQL Plus to run in the sql file, everything worked fine.
So I have concluded that inorder to run in a trigger or any PL/SQL code I need to use SQL plus to send it to the database.
Am I correct?
Raj Received on Tue Feb 03 2004 - 10:39:21 CST