Displaying 1 result from an estimated 1 matches for "foo_sequ".
Did you mean:
foo_seq
2006 Mar 02
1
Insert a data in Oracle with Rails
...r 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 Works!.
Where is the problem??? The column named ''id'' is necessary with
oracle?And it must be "Auto_Increment".
--
Posted via http://www.ruby-forum.com/.