Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Trigger
"Rajesh Patel" <rpatel_at_rajix.com> wrote in message
news:HsIoxM.8r4_at_news.boeing.com...
| 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
|
no
properly formed SQL statements should be executable via any interface that establishes a database connection
post more details about your code and error messages
![]() |
![]() |