Displaying 2 results from an estimated 2 matches for "foo_seq".
Did you mean:
do_seq
2006 Mar 01
2
Oracle auto_increment ??? & Rails
To make a new istance of an Oracle table with Rails, i need that this
table had a column named ''id''. This ''id'' must be Primary Key &
auto_increment;.
How Can I modify the ''id'' properties to do it Auto_increment in Oracle?
--
Posted via http://www.ruby-forum.com/.
2006 Mar 02
1
Insert a data in Oracle with Rails
...LL
)
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 Works!.
Where is the problem??? The column named ''id'' is necessary with
oracle?And it must be "Auto_Increment&...