Home/ASP.NET Forums/Data Access/Oracle, MySQL, Sybase, Informix and other databases/How to update data returned using REF CURSOR

How to update data returned using REF CURSOR RSS

4 replies

Last post May 15, 2009 06:43 AM by wmec

Oracle .net 2.0 VS.2005 c# asp.net 2.0 Using REF cusror with ADO.net dataset Oracle Package ado.net Ref Cursors

  • Tung.TranThanhTung

    Tung.TranTha...

    Member

    4 Points

    2 Posts

    Re: How to update data returned using REF CURSOR

    May 13, 2009 08:35 AM|Tung.TranThanhTung|LINK

    I have same problem with you (http://forums.asp.net/t/1231115.aspx), I can't insert, update, delete if using store procedure but I can use select. Are you find the way to correct it ? Please help me

    Thanks

  • dweezil

    dweezil

    Participant

    1873 Points

    395 Posts

    Re: How to update data returned using REF CURSOR

    May 13, 2009 04:13 PM|dweezil|LINK

    First, none of your procedures that contain DML statements (insert,update,delete) are not followed by a COMMIT statement.

    I would start there and see if that fixes the issue. If not, post back here.

    --dweezil

    SELECT * FROM users WHERE clue = 'yes';

    Records found: 0
  • Tung.TranThanhTung

    Tung.TranTha...

    Member

    4 Points

    2 Posts

    Re: How to update data returned using REF CURSOR

    May 15, 2009 03:51 AM|Tung.TranThanhTung|LINK

    I kown in code don't have select command because I don't public my code in forum. But I have same problem to insert when using store procedure. Can you correct it ?

    Thanks

  • wmec

    wmec

    Star

    9513 Points

    4660 Posts

    Re: How to update data returned using REF CURSOR

    May 15, 2009 06:43 AM|wmec|LINK

    Is there any error returned or any run-time error?

    Many Thanks & Best Regards,
    HuaMin Chen
  • ‹ Previous Thread|Next Thread ›