tag:blogger.com,1999:blog-4301764760924839143.post8920847067030892592..comments2023-05-28T17:05:46.108+02:00Comments on Andrejus Baranovskis Blog - JDev/ADF Samples list: JDev/ADF sample - LOV in Create Form with Mandatory FieldsAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4301764760924839143.post-56361117296707085762013-03-05T14:27:29.776+01:002013-03-05T14:27:29.776+01:00For example, check here: http://www.razorsql.com/f...For example, check here: http://www.razorsql.com/features/oracle_add_sequence_trigger.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-4301764760924839143.post-92056281571681727842013-03-05T11:13:46.202+01:002013-03-05T11:13:46.202+01:00dear
how to create this trigger
regardsdear <br />how to create this trigger<br />regardsAnonymoushttps://www.blogger.com/profile/15243074651007326742noreply@blogger.comtag:blogger.com,1999:blog-4301764760924839143.post-13478373133423399562008-07-22T19:00:00.000+02:002008-07-22T19:00:00.000+02:00Hi,May be you didnt created trigger in database?Re...Hi,<BR/><BR/>May be you didnt created trigger in database?<BR/><BR/>Regards,<BR/>AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-4301764760924839143.post-41949321818972604862008-07-22T04:22:00.000+02:002008-07-22T04:22:00.000+02:00I am getting the following error when trying to cr...I am getting the following error when trying to create a new employee: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO EMPLOYEES(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,DEPARTMENT_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9) RETURNING EMPLOYEE_ID INTO :10; END;".<BR/>Error <BR/>ORA-01400: cannot insert NULL into ("HR"."EMPLOYEES"."EMPLOYEE_ID") ORA-06512: at line 1 <BR/><BR/>I have verified that a DB Sequencer called EMPLOYEES_SEQ does exist in the DBUnknownhttps://www.blogger.com/profile/15843483862806244342noreply@blogger.com