3 Replies Latest reply on Aug 16, 2005 8:26 AM by 416900

    How to use the 'DatabaseOperation' mapping in iStudio?

    88549
      I'm still a novice in using iStudio and would like to use the 'DatabaseOperation' mapping - but so far I've had no joy. For Test purposes I have created a function:

      FUNCTION test_value (p_operator_name IN VARCHAR
      , p_status IN VARCHAR) RETURN VARCHAR IS
      l_return varchar2(100);
      BEGIN
      l_return := 'This is a test';
      RETURN l_return;
      END;

      iStudio
      Destination Field
      $Test.s1

      Source Field
      DatabaseOperation (operator_name, status, "oaihub902", "***password", "***host", "1521", "***SID", "thin", "5", "20", "begin test_value(operator_name,status);end;")

      Error
      oracle.oai.agent.server.transform.database.DBTransformationException: PLSQLTrans
      formation.transform: Transformation failed

      I can't find any documentation on how to use this mapping .. so any help would be appreciated.

      Cheers

      Ed