6 Replies Latest reply: Feb 4, 2013 5:18 AM by XYZ123 RSS

    Using plsql variable in Java Bean Shell

    XYZ123
      Hi everyone,

      I need to assign a plsql variable's value to a java bean shell in knowledge module design. Something like that:
      declare
       x integer;
      begin
        x := 5;
        <? javabeanShellVariable = x ?>
      end;
      I could use the java bean variable in sql statement but I could not learn how to use plsql variable in java bean shell. Is it possible or not?

      I am using ODI 10.1.3.5, Oracle 11g R2.

      Thanks.

      Edited by: XYZ123 on 01.Şub.2013 14:09

      Edited by: XYZ123 on 01.Şub.2013 16:48