Displaying 1 result from an estimated 1 matches for "pippolo".
Did you mean:
pippola
2006 Mar 02
1
Insert a data in Oracle with Rails
...is Oracle table:
CREATE TABLE "FOO" (
"id" int NOT NULL primary key,
"acolumn" VARCHAR(10) NULL
)
and when i tried to insert a new row the Rails compiler tell me :
OCIError: ORA-00904: invalid column name: INSERT INTO AGO.FOO (acolumn,
id) VALUES(''pippolo'', :id)
While with MySQL I''ve no problem using the same table!.
I tell to Oracle also :
CREATE SEQUENCE FOO_SEQ INCREMENT BY 1 START WITH 100
or :
CREATE SEQUENCE FOO_sequence
START WITH 1
MAXVALUE 9999
MINVALUE 1
NOCYCLE
CACHE 200
ORDER
But It doesn''t Wo...