SQL in Stored procedures not being picked up

[lisa_burrow]

Hi,

I have some SQL in a stored procedure that is selecting data from a database and then making that data available in a drop down list on my website.

I have made a change to this SQL but am unable to get my website to pick up my changes.

Is there something that I need to do to refresh/update to make the environment pick up the new changes?

I have run a Maven compile and deployed that to my environment but that didn't pick up my changes.

Thanks. Lisa.

[arunpatidar]

Hi,

where are you checking this Author or Publish. Make sure the service response is not cached on dispatcher.

[lisa_burrow]

Hi Arun, I am checking this in Publish. I have already cleared the dispatcher cache.