2 Replies Latest reply on Jan 16, 2013 1:44 PM by aetl

    odi 10g functions

    aetl
      Hi everyone,

      I have a function like this:

      CREATE OR REPLACE FUNCTION ODS.fnoteconv (row_id VARCHAR)
      RETURN varchar2
      AS
      v_row_id VARCHAR2 (15);
      v_dblink VARCHAR2 (10);
      v_note VARCHAR2 (4000);
      BEGIN
      v_row_id := row_id;
      v_dblink := 'SBL';

      EXECUTE IMMEDIATE
      'SELECT NOTE
      FROM SIEBEL.S_NOTE_SR@' || v_dblink || ' WHERE row_id = :1'
      INTO v_note
      USING v_row_id;


      RETURN v_note;
      END;

      Now I don't want to create this function on DB.Just I will create this function in ODI.On my mapping I will send row_id of Source like this function(SOURCE.row_id) then I will map return value into a column.Is it possible?

      Regards