I am creating an oracle database using ODBC.. everything works except the triggers.. they all produce this error:
PLS-00103: Encountered the symbol "" when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise
return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql commit <a single-quoted SQL string>
The symbol "" was ignored.
I have not fooled with this message. Oracle does not like the symbol it identifies as "" (Nothing!)
The strange thing is, when I extract the (Invalid) trigger script using TOAD and post it back into oracle it compiles without errors. Anybody got any ideas about why it's failing using ODBC ?