Windows Oracle Data Access Components (MOSC)

MOSC Banner

SQL Developer calling update sproc works fine, but same call via ADO/ASP works but doesn't update

edited Jan 31, 2010 9:13PM in Windows Oracle Data Access Components (MOSC) 4 commentsAnswered
 Hi,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center