search for: nocycl

the compiler tell me it: invalid column name: INSERT INTO ago.prova_stats (cognome, nome, id, telefono) VALUES(''Medda'', ''Ivan'', :id, 70565611) where ago.prova_stats is the table used by me and that have only the columns ''cognome'',''nome'' and ''telefono''. My table hasn''t the column

...RT 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/.

...ed out (by stepping through oci8.rb) that > the > name of the sequence should be "sessions_seq". For that I used the > following snippet: > > CREATE SEQUENCE ACS_SUPPORT.SESSIONS_SEQ > START WITH 50 > MAXVALUE 999999999999999999999999999 > MINVALUE 0 > NOCYCLE > CACHE 50 > NOORDER; > > Unfortunately, there are still problems, and here''s where I''m not sure > what''s happening: > > [2007-10-04 15:53:24] INFO WEBrick 1.3.1 > [2007-10-04 15:53:24] INFO ruby 1.8.6 (2007-03-13) [i386-mswin32] > [2007-...

...h I had no idea was required, but ok). I figured out (by stepping through oci8.rb) that the name of the sequence should be "sessions_seq". For that I used the following snippet: CREATE SEQUENCE ACS_SUPPORT.SESSIONS_SEQ START WITH 50 MAXVALUE 999999999999999999999999999 MINVALUE 0 NOCYCLE CACHE 50 NOORDER; Unfortunately, there are still problems, and here''s where I''m not sure what''s happening: [2007-10-04 15:53:24] INFO WEBrick 1.3.1 [2007-10-04 15:53:24] INFO ruby 1.8.6 (2007-03-13) [i386-mswin32] [2007-10-04 15:53:24] INFO WEBrick::HTTPServer#s...