Re: [PHP-DB] Oracle Auto_Increment Error

2003-10-14 Thread Christopher Jones
Roger, You can see the real Oracle error number if you replace the getMessage() calls with getDebugInfo() or getUserInfo(). Making this change gave this output: Connecting . . . CREATE TRIGGER test_trigger before insert on test for each row begin select test_seq.nextval into :new.id from

[PHP-DB] Oracle Auto_Increment Error

2003-10-14 Thread Roger Spears
Hello, BACKGROUND: I'm able to create tables in oracle, populate fields in oracle tables, select, retrieve and update fields in oracle. So I know my connection code is working. PROBLEM: I'm working with PHP and PEAR and I'm trying to create an auto_increment field in an oracle database table.