SQL Developer calling update sproc works fine, but same call via ADO/ASP works but doesn't update
I'm not sure if this is the forum I should use, but I've been struggling for days on this issue. I have several update stored procedures that are working fine in my ADO/ASP environment. Now, however, I needed to create a dynamic query/update which required me to use execute immediate. The procedure works great in SQL Developer and updates the necessary rows.
When I execute it in ADO/ASP, I get no errors, but the data is not updated either. Does something different have to be done on the ASP side when execute immediate is used for the update?