Hi,<br><br>I'm trying to create this SP:<br><br>create trigger test_addid before insert on mytest<br>for each row<br>begin<br> :new.fred_id := select get_my_id.NextVal from dual; <br>end;<br><br>I also tried:<br>:new.fred_id := get_my_id.NextVal<br><br>and some other variations. They all produce the surprisingly useless message:<br><br>[Oracle][ODBC][Ora]Trigger, procedure or function created with PL/SQL compilation error(s).<br><br>Any help anybody could provide would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SP Causing Misterious Compilation Error
- Thread starter jgotthelf
- Start date
Similar threads
- Locked
- Question