Home > Oracle > Oracle Triggers – ORA-00911

Oracle Triggers – ORA-00911

This was supposed to be a computer blog.  Sorry about that last rant about baseball.  I can’t promise that will be the last one though.

Should you have to write a trigger in Oracle make sure that your column names do not start with a special character.  You can use ‘#’ as the first character in a column name but I had an issue today where the trigger would create properly.  I was getting ORA – 00911 Invalid Character error.  I renamed the column in question from #_OF_WIDGETS to NUM_OF_WIDGETS and everything worked just fine.

Probably wasn’t the best idea in the world to name my column that way in the first place.

Gregg

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: