I admit it–I’m newb right now. But only to rails, ruby and friends.
I’m walking through a “recipe” tutorial but have been stuck for hours;
it’s time to ask for help. On Windows I’ve got the latest ruby, rails,
and webrick; I’ve got the Oracle OCI “thing” to talk to our Oracle 10g
database, I’ve got Slick Edit and a command line.
I’ve created a recipes table, a sequence to feed its ID primary key
column, and a trigger that gets fired before record creation. I can use
sql at a command line in Oracle’s sqlplus to add records. No sweat.
But in the browser I get:
ActiveRecord::StatementInvalid in RecipeController#create
OCIError: ORA-02289: sequence does not exist: select recipes_seq.nextval
id from dual
I did once have a sequence with that name, but that’s long gone. In
fact I’ve dropped and recreated the table, sequence and trigger several
times with new names (except I continue using “recipes” for the table
I’ve closed and opened and closed firefox. I’ve restarted webrick.
I’m having trouble imagining what’s up–because I believe this little
ruby app isn’t looking into the details of how an incrementing field
works. There are clearly remnants somewhere, I just can’t find them.
Thanks anyone for getting me back on track.