3 Replies Latest reply: Feb 13, 2013 1:43 AM by Bhabani Ranjan RSS

    Blank value Variable with OracleDiagent throwing error

    984374
      Hi All,

      In my process i am using 3 variables as input #GL_Product_code,#GL_Period_no,#GL_Year based on this i need to fetch all other details ,if i given any of this input value blank based on other two inputs it needs to fetch the value,below code in where condition
      ......where product_code=nvl('#GL_Product_code',product_code) and period_no=nvl('#GL_Period_no',period_no) and year=nvl('#GL_Year',year)

      but when i use local agent my process executing with out errors,when i executing with OracleDiagent its throwing error as variable has no value

      Error details

      oracle.odi.core.exception.OdiRuntimeException: java.lang.Exception: ODI-17506: Variable has no value: GL_VALIDATE.GL_PERIOD_NO

      Thank you for your suggestion .......

      Edited by: 981371 on Feb 11, 2013 9:53 AM

      Edited by: 981371 on Feb 12, 2013 2:28 AM

      Edited by: 981371 on Feb 12, 2013 10:10 PM