Hello, Thanks for your answer.
I've seen this page, i had already modified my code like it is recommanded. I have the version just before the latest stable CakePHP 1.2.5 : mine is 1.2.4.8284 I've seen the changelog of the 1.2.5 version, it doesn't seems that this version correct a bug relatively to Oracle. Any suggestions ? Thanks in advance. On 17 oct, 05:59, Dérico Filho <[email protected]> wrote: > Check out this bug, see if it has anything to do with > you:https://trac.cakephp.org/ticket/4181 > > Which CakePHP version you're using? Please, make a backup from your > code, and try pulling from [email protected]:cakephp.git to see if > this problem is solved with latest devel version. > > []s > Dérico Filho > > On Oct 16, 10:48 am,Xanax<[email protected]> wrote: > > > Good morning everyone, > > > I'm using CakePHP with Oracle and sequences (i can't use triggers > > because it's forbidden in my company...) > > > I CAN'T add record to my database through my CakePHP app. > > > I respected all naming conventions. > > > I have a table name "PROJET", his ID is a"number" type, not null. > > I've created a sequence called "PROJET_ID_SEQ' AND 'PROJETS_ID_SEQ'. > > I've launch "select PROJET_ID_SEQ.nextval from dual" and "select > > PROJET_ID_SEQ.nextval from dual" because if you lauch a "select > > PROJET_ID_SEQ.currval from dual" ORACLE crashes saying you must do a > > nextval at the first time... > > > Plus i added : > > var $sequence = 'PROJETS_ID_SEQ'; > > in my projet sequence to be more explicit... > > > Then i try to add a new project > > When i launch the debug from the dbo_oracle.php and i display > > "$model->sequence", it shows up : > > > PROJETS_ID_SEQ > > > So it's looks fine... BUT it doesn't work at all. He seems that > > Cakephp doesn't use this sequence so i have this error : > > SQL Error: ORA-01400: cannot insert NULL into > > ("PLAN_TEST"."PROJETS"."ID") > > > Do you have any idea of what i am missing please ? > > > Thank you very much for any help because i am relly getting mad about > > this! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
