2 Replies Latest reply: Aug 6, 2013 11:50 AM by 970462 RSS

    ORA-00936: missing expression

    970462


      Hi Everyone

       

      I am getting an error when I try to run a SDE mapping in Informatica.It gives me the following error:

       

      Severity Timestamp Node Thread Message Code Message
      ERROR 08/05/2013 5:51:21 PM node01_hrbiappd.cha.tva.gov READER_1_1_1 PR_18012 SQL Error [
      ORA-00936: missing expression

      Database driver error...
      Function Name : Execute
      SQL Stmt

       

      When I try to run my Sql statement in SQL developer it works fine but its not working in mapping.I researched online and found out that it has to do something with parameter which is passing through DAC but I am unable to figure out where could be the reason.

       

      Can anyone please help me with the error.

       

      Thanks in Advance!!!