1 Reply Latest reply: Dec 8, 2012 10:48 PM by 948533 RSS

    regarding odi procedures

    ksbabu
      Hi Friends,
      I am new to ODI,i have knowledge in plsql procedures,i want to delete data
      from target table for that i have written procedure like this

      create or replace procedure del_region
      as
      begin
      delete from src_region;
      dbms_output.put_line(reid||' '||name||' '||country);
      end;

      but it is not working,if is different in ODI plse guide me

      thanks
      sateesh