SQL Listener Custome Status Column states

[srikanth_vals]

Hi,
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,
Sri.

[srikanth_vals]

"srikanth_vals" wrote:
Hi,
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,
Sri.

[marklittle]

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.

[burrsutter]

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.

Burr

[srikanth_vals]

Yes for now we added a separate column.

Thanks,
Sri.