Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Trigger

Re: Oracle Trigger

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 3 Feb 2004 13:01:33 -0500
Message-ID: <1uCdnVGadJ-7f4LdRVn-uw@comcast.com>

"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

Received on Tue Feb 03 2004 - 12:01:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US