I have a EMP table with two columns (1) Emp_id (2) emp_status. And emp_status accepts only values like N,X,Y. But the SQL listener works only when the status-column value is 'P' in the emp_status. My requirement is i want to get the newly inserted rows in EMP table. Is there a way to get rows of table without looking for any status-column column or can i change the default status-column values?
!!!! URGENT PLEASE !!!!
Thanks and Regards,
Please explain your problem in more detail. What you've got here (twice) is hard to parse. We're in the final stages of a GA release, so anything that is hard to parse is likely to get lower priority.
You may need to create a 3rd column. We need our own "status" column.
At least that is how I remember it working (not looked in a little while).
Also, consider the Hibernate gateway as well. It is MUCH more flexible.
Yes for now we added a separate column.