ASP.NET OracleDataSource with delete command

ASP.NET OracleDataSource with delete command

Postby hannes_a » Wed 14 Jul 2010 13:46

I use a OracleDataSource with a complex delete PLSQL command,
but it has during debug only paramter Original_ID.
I need your assistance to solve this, or is it a bug ?

Code: Select all
        DeleteCommand="declare
  v_migration number := 0;
  cursor c_instbase(p_instbase_id IN number) is
    select migration from instbase
      where id = p_instbase_id
      for update of migration NOWAIT;
begin
  OPEN c_instbase (:INSTBASE_ID);
  loop
    FETCH c_instbase into v_migration;
    exit when c_instbase%NOTFOUND;
    if v_migration = 2 then
      update instbase set migration = 0 where current of c_instbase;
    end if;
  end loop;
  CLOSE c_instbase;
  DELETE FROM SYSCONFIG WHERE ((ID = :Original_ID));
end;"
SelectCommand="select instbase_id, id from sysconfig sc">
       
           
           
       


(I removed unneccassary information)


btw: thank you for solving "Fixed bug with executing a PL/SQL block with two parameters of the same name" 5.70.140 20-May-10
http://www.devart.com/forums/viewtopic. ... highlight=
hannes_a
 
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Postby Shalex » Thu 15 Jul 2010 14:39

I have tried your sample with our database with the 5.70.146 build of dotConnect for Oracle. dbMonitor showed two parameters: INSTBASE_ID and ORIGINAL_ID. If you navigate to OracleDataSource Editor in design time, there also will be two parameters in the delete command editor. Could you please specify the result you were expecting to get? If there is a problem, please send us a complete small test project with the DDL/DML script to reproduce the problem in our environment.
Shalex
Devart Team
 
Posts: 7391
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle