Beginner here, so this should be easy.
I created an RoR application that worked against and sqlite3 table. But
the next step was for it to work against an Oracle table.
So, I’ve changed the database.yml file to look at Oracle, and I’ve
created the same table on Oracle as was on sqlite3. My table is called
Name Null? Type
ID NOT NULL NUMBER
and I have created the sequence
create sequence list_item_seq;
But I’m getting the error - ORA-02289: sequence does not exist. I’ve
tried other similar names to no avail.
We do have the primary key plug in installed, so I add to the empty
model the line
I then get a different error
cannot insert NULL into (“GLOBE”.“LIST_ITEMS”.“ID”): INSERT INTO
list_items (name, cost, quantity, id) VALUES (‘fred’‘s pizza’, 10.0,
Any clues as to where/what to look at? Shouldn’t it “just work”?
Thanx for any help