"Mark Filson" <mfilson29NOSPAM_at_hotmail.com> wrote in message
news:lpMzb.9514$d35.2257_at_edtnps84...
| Hi All,
|
| Here's the issue I'm having... I have a VB COM component that is used to
| parse SQL files and apply them to an instance of Oracle. Most of the
| statements in the sql file work but a few don't. Here is an example of an
| offending one:
|
|
| CREATE OR REPLACE TRIGGER TR_SEQ_APPLICATION_SETTINGS
| AFTER INSERT OR UPDATE ON APPLICATION_SETTINGS
| FOR EACH ROW
| BEGIN
| SELECT SEQ_APPLICATION_SETTINGS.nextval INTO :new.ID FROM dual;
| END TR_SEQ_APPLICATION_SETTINGS;
| /
|
|
| The Sequence that's referenced is created successfully and my code says
that
| the trigger is created (ie, no errors are thrown), but when I attempt to
| insert a bunch of values into the table APPLICATION_SETTINGS, errors are
| generated. Is there something about the syntax of this create statement
| thats wrong. For what it's worth, the above statement can be run in SQL
| PLUS successfully and the trigger is created.
|
| Cheers.
|
|
if the statement works in SQL*Plus, and you checked the data dictionary to
make sure the trigger is valid, then the issue seams to be the errors that
are being generated when you do your inserts -- how 'bout if you post those?
--
Mark C. Stock
mcstock -> enquery(dot)com
www.enquery.com training & consulting
Received on Thu Dec 04 2003 - 15:04:19 CST
