Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00936: missing expression

User_TYZ1TAug 6 2013 — edited Aug 6 2013


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!!!

This post has been answered by SunilSharma on Aug 6 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2013
Added on Aug 6 2013
2 comments
1,337 views